Back
|
|
|
ORACLE PL/SQL STORED PROGRAM UNITS
Delegates: |
|
This course, designed for Oracle programmers and developers, provides practical experience in writing triggers, functions, procedures and packages. It also introduces some of the Oracle-supplied packages including DBMS_LOB for handling Large Objects.
|
Objectives: |
By the end of this course, the delegate will be able to write and manage stored program units, implement package
constructs and features and handle Large Objects programmatically.
Together with the PL/SQL course, this course is suitable for delegates intending to sit the
Oracle PL/SQL Developer Certified Associate examination #1Z0-147: Program with PL/SQL.
This course is also suitable for delegates intending to sit the Oracle Internet Application Developer Rel. 6i Certified Professional examination #1Z0-101: Develop PL/SQL Program Units.
|
Note: |
|
Before taking any exam, ensure you 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
- 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
- The DBMS_METADATA Package
- Overview of the UTL_FILE Package
- Using UTL_MAIL
- Overview of DBMS_SCHEDULER
- Overview of the HTP Package
- Large Objects - CLOBs, BLOBs and BFILEs
- Using the DBMS_LOB Package for Handling Large Objects
|
Requirements:
|
|
Practical experience of Oracle SQL*Plus or iSQL*Plus and a good working
knowledge of the fundamentals of the PL/SQL programming language is required.
This can be gained by attendance on the pre-requisite courses.
|
|
|
|
