Back to Search Results

Training Course Summary:

This course is designed for Oracle programmers and developers and provides practical experience in writing stand-alone PL/SQL programs and database triggers, functions, procedures and packages. It also introduces some of the Oracle-supplied packages including DBMS_LOB for handling Large Objects.

By the end of this course, the delegate will be able to write PL/SQL programs, manage stored program units, implement package constructs and handle Large Objects programmatically.

Pre-Requisites:

Attendance on the pre-requisite Oracle SQL course and practical experience in writing SQL statements. Some prior programming experience will also prove advantageous.

Training Course Overview/Content:

The PL/SQL Program Structure
Variables and Constants
Using SQL in PL/SQL Programs
Generating Output
IF Statements, CASE Expressions and LOOP Constructs
Cursors and Cursor Loops
Exception Handling
PL/SQL Records and Tables
Creating and Managing Triggers
Creating and Managing Stored Procedures and Functions
Passing Parameters to Stored Program Units
Creating and Managing Packages
Implementing Package Features and Constructs
Using PL/SQL Records and Tables in Packages
Bulk Collection and Bulk Binding Operations
Managing Program Unit Dependencies
Native Compilation and Compile-time Warnings
Overview of Oracle Supplied Packages
Native Dynamic SQL
Using UTL_FILE
Scheduling Jobs using DBMS_SCHEDULER
Introduction to the DBMS_METADATA, UTL_MAIL and HTP Packages
Large Objects and the DBMS_LOB Package