Oracle PL/SQL Stored Program Units — A 3 day course

contact usEnquire about this course


This course provides practical experience in developing and writing triggers, functions, procedures and packages. It also introduces some of the Oracle-supplied packages.

Together with the PL/SQL course, this course is suitable for delegates intending to sit the Oracle examination #1Z0-147: Program with PL/SQL.

Examinations are not included as part of the course and anyone intending to sit examinations should check directly on the Oracle website for up to date requirements.


The delegates will practise:

Suitable For

Oracle database administrators and software development personnel who need to write new, or maintain existing, PL/SQL triggers, program units and packages.


Practical experience of Oracle SQL and SQL*Plus or SQL Developer and a good working knowledge of the fundamentals of the PL/SQL programming language are required. This can be gained by attendance on the Oracle PL/SQL and SQL courses.

Publicly scheduled dates, locations, and prices

Select a date to enquire about availability of places. For dates after 24 February 2017, please call 0333 210 0140 or use our contact form to enquire about places and availability.

London — £1195 (+VAT)

Sunderland — £1195 (+VAT)






Using PL/SQL Records and Tables in Packages

Cursor Variables (Ref Cursors)

Managing Dependencies

Native Compilation and Compile-Time Warnings

Oracle-Supplied Packages

Creating a Database Access Descriptor

Handling Large Objects