Back to Search Results

Training Course Summary:

Delegates:

This course is designed for experienced PL/SQL Programmers who require a deeper knowledge of the product.

Objectives:

By the end of this course, the delegate will have a better understanding of how to use PL/SQL to write their own packages, manipulate BLOBs, CLOBs and External Files, handle Object Types and Collections and use other advanced PL/SQL features.


Topics Covered:

Review of PL/SQL
Overview of Procedures, Functions and Procedures
Best practices for developing "in-house" packages.
Overloading
Local Sub-Programs
Reusing Package Memory
Cursors and Packages
Wrapping a Package
Handling External Files
Manipulating Large Objects
Oracle Object Oriented Support.
Object Types
Object Tables
Object Methods
Collections
Variable Arrays and Nested Tables
Features introduced since Oracle 8i
Native Dynamic SQL
Bulk Binding
Purity
The RETURNING Clause
Performance considerations
Overview of other Supplied Packages

Requirements:

Attendance on the Pre-Requisite course and an overall awareness of the Oracle RDBMS in general.

Pre-Requisites Courses:

PL/SQL Stored Program Units


Follow-On Courses:

PL/SQL Web Applications

Forms 6i - Part I

Reports

DBA Part I - Architecture & Administration