Advanced PL/SQL

Course Overview

This course is the follow-on from Fundamentals of PL/SQL. The main areas of PL/SQL that the course focuses on are procedures, functions and packages. The course also covers triggers, collections and exception handling in named-blocks to complete the delegate’s knowledge of PL/SQL.

Collections

• Index-By Tables and their uses
• IBT Functions
• Varying Arrays
• Nested Tables
• Management Issues

Procedures and Functions

• Creating procedures with no arguments
• Creating procedures with arguments
• Creating functions
• Error handling
• Dropping procedures and functions

Packages

• How packages are used
• The package body and specification
• Creating, using and dropping packages
• Initialising packages
• Overloading procedures
• Viewing source code
• Compiling functions, procedures and packages

Triggers

• Trigger components
• Statement and row triggers
• Multi-purpose triggers
• Customising error conditions
• DDL Triggers
• Database event triggers
• Enabling and disabling triggers

Supplied Packages

• DBMS_ALERT
• DBMS_JOB
• DBMS_OUTPUT
• DBMS_PIPE
• DBMS_SQL