Oracle PL/SQL Stored Program Units
Course
In Leeds and London
Description
-
Type
Course
-
Location
-
Duration
3 Days
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.
Facilities
Location
Start date
Start date
Start date
Reviews
Course programme
- CreatingDMLTriggers
- Creating ONDATABASEand ONSCHEMATriggers
- 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 inSQL
- 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 DynamicSQL
- Oracle Supplied Packages
- The DBMS_METADATA Package
- Overview of DBMS_SCHEDULER
Oracle PL/SQL Stored Program Units