< Go back to Oracle PL/SQL training course
Editor (add & remove topics to suit your needs)
Creating Procedures, Functions and Packages
Executing & Using Procedures, Functions & Packages
Private & Public Execution
One-time only Procedures
Declarations and variable assignment.
Assigning Default Values and Constants
Defining Records and Tables of Records
SQL*Plus commands in PL/SQL
Restrictions on Embedded SQL
Manipulating Multiple Records
Defining and using Ref Cursors.
For Update and Where Current of Clauses
Embedded Insert, Update, Delete commands.
Exiting Loops to a Label
Block Labels and Nested Blocks
Basic, FOR, While and Cursor For loops
Nested Loops and Variable Scope
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
Audience & Requirements
Duration, location and dates
If you have a course length in mind, please select from the list
More than 5 days
Where would you like the course to be held?
On your site
At our London offices
Please quote for both options
Where is your site located?
If you have a date and location in mind, enter them here....
Complete the form oppositebelow to get your quote >>>
GET A CUSTOM COURSE QUOTE
Complete this form for an instant quote Or for more information call 0800 028 6400