Overview 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. It also introduces some of the Oracle-supplied packages including DBMS_LOB for handling Large Objects.
Pre-Requisites
Delegates are required to meet the following prerequisites:
SQL (OSP) Some prior programming experience will also prove advantageous.
Next Course Dates
Dates available on request. Please contact us
More Information
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.
- Write PL/SQL programs
- Manage stored program units
- Implement package constructs
- Handle Large Objects programmatically
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
This course relates to the following exams:
- Oracle 9i PL/SQL Developer Certified Associate Examination #1Z0-147.
- PL/SQL Web Applications (OPWA)
- Forms 6i - Part I (OF1)
- Forms - Part I (OF19I)
- Reports (OR)
- DBA Part I - Architecture & Administration (ODA)
- Oracle Database 10g DBA - Part I (O10GDBAI)