Oracle PL/SQL Stored Program Units

Delegates:

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

Objectives:

By the end of this course, the delegate will be able to write and manage stored program units, implement package constructs and features. They will also be able to describe and use 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 .

Note:

Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience.

Topics Covered:

• Creating DML Triggers
• Creating ON DATABASE and ON SCHEMA Triggers
• Managing Triggers
• Creating and Managing Stored Procedures
• Parameters and Parameter Modes
• Local Subprograms
• Autonomous Transactions
• Creating and Managing Stored Functions
• Deterministic Functions
• Using Stored Functions in SQL
• Creating and Managing Packages
• Implementing Package Features and Constructs
• Wrapping Packages
• Cursor Variables
• Using PL/SQL Records and Tables or Associative Arrays in Packages
• Bulk Binding and Bulk Collecting Operations
• Managing Dependencies
• Native Compilation and Compile Time Warnings
• The DBMS_SQL Package
• Native Dynamic SQL
• Oracle Supplied Packages
• The DBMS_METADATA Package
• Overview of DBMS_SCHEDULER