www.jbinternational.co.uk sales@jbinternational.co.uk Call Free 0800 028 6400

JB International 1345 High Road London, N20 9HR +44 (0) 20 8446 7555

 

Introduction to Oracle PL/SQL Training Course UK

Dates and full course list

Introduction to Oracle PL/SQL Course Overview

Course Code:	ORC0020
Price:	£700
Duration:	2 days
Date:
Who should attend:	The course is suitable for technical personnel involved in the development and maintenance of Oracle applications and databases.
Prerequisite Skills:	Delegates should have attended the Oracle 9i Introduction to SQL course.

The course outlines techniques used in the advanced manipulation and extraction of data and adds a procedural element to the processing of data from an Oracle database. Lectures are combined with sets of exercises designed to illustrate the points covered. These exercises are to be completed by the delegate.

Course Content

This course has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus. If you have a technical question, please email

Course Objectives

1. Produce procedural programs using PL/SQL
2. Perform transactions using PL/SQL.
3. Manipulate data using advanced techniques including nested functions.

Introduction to Oracle PL/SQL Training Course Outline

PL/SQL

PLSQL Blocks
Creating Procedures, Functions and Packages
Executing & Using Procedures, Functions & Packages
Private & Public Execution
One-time only Procedures
Overloading

Declarations and variable assignment.

Data Types
Bind variables
Assigning Default Values and Constants
Table Arrays
Defining Records and Tables of Records

SQL*Plus commands in PL/SQL

Embedded SQL
Restrictions on Embedded SQL

Cursors

Defining Cursors
Manipulating Multiple Records
Parameterising Cursors
Defining and using Ref Cursors.

Data Manipulation

For Update and Where Current of Clauses
Embedded Insert, Update, Delete commands.

Conditional Branches

Labels
Exiting Loops to a Label
Block Labels and Nested Blocks

Loops

Basic, FOR, While and Cursor For loops
Nested Loops and Variable Scope

Exception handling

Handling Runtime Errors
System Handled Exceptions
User Defined Exceptions
PRAGMA INIT and Compiler Instructions
How to continue processing after an Exception

Debugging Your PL/SQL

Associated Courses

Oracle 9i Intro to PL/SQL
Oracle 9i DBA
Oracle 9i New Features
Oracle 9i Performance Tuning