Oracle Program with PL/SQL

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. Together with the SQL course, this course is suitable for delegates intending to sit the Oracle PL/SQL Developer Certified Associate examination #1Z0-001: Introduction to Oracle SQL and PL/SQL. 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: Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience. Course content

• The PL/SQL Program Structure
• Variables and Constants
• UsingSQLin PL/SQL Programs
• Generating Output
• IF Statements,CASEExpressions andLOOPConstructs
• 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 DynamicSQL
• Using Oracle Supplied Packages
• Introduction to the DBMS_METADATA, UTL_MAIL, DBMS_APPLICATION_INFO and DBMS_UTILITY Packages
• Scheduling Jobs using DBMS_SCHEDULER