0845 450 6120

Oracle Advanced PL/SQL

Software development personnel and Oracle database administrators who need to take advantage of the advanced features of PL/SQL in Oracle Database 10g and Oracle Database 11g.

Learning Objectives

By the end of this Oracle Advanced PL/SQL course delegates will be able to effectively tune PL/SQL code; create subtypes; create and use collections; execute external C programs and Java programs from PL/SQL; use fine-grained access control; use LOB data types and the DBMS_LOB package; use SecureFile LOBs; effectively design cursors; improve memory usage with PL/SQL result caching and SQL result sets and apply coding standards to avoid SQL injection attacks.


Practical experience of Oracle SQL or SQL Developer and a good working knowledge of the fundamentals of the PL/SQL programming language are required.

Course Content

This course, designed for Oracle database administrators and software development personnel who need to gain practical experience of the advanced features of PL/SQL such as program design, packages, cursors, large objects and collections.

It also introduces some of the Oracle-supplied packages.

This Oracle Advanced PL/SQL course is suitable for users of Oracle Database 10g and Oracle Database 11g.

Exams & Certification

This Oracle Advanced PL/SQL course is suitable for delegates intending to sit the Oracle examination #1Z0-146: Oracle Database 11g: Advanced PL/SQL.

Exams are not included as part of the course.

Before taking any exam, ensure you have the recommended experience.  The Oracle website lists all exam requirements and these are updated regularly.

One Month
Two Months
Three Months
More than Three Months
PRINCE2 Foundation & Practitioner
MSP Foundation & Practitioner
APMP Certificate
ITIL Foundation
Scrum in One Day
Certified ScrumMaster
ISTQB Software Test Foundation
Microsoft Project
BCS Business Analysis Practice
Other - Please Specify Below

Our Customers Include