1. Introduction to PL/SQL
Features and benefits of PL/SQL
Relationship of PL/SQL to SQL
PL/SQL development tools
Native compilation
PL/SQL system/session params
PL/SQL anonymous block Variable declarations
PL/SQL types and Records
Declaring variable datatypes dynamically
Modifying database data (DML)
Transaction control statements
Declaring explicit cursors
Implicit cursor attributes
Exception handling
Creating procedures, functions, packages, and DML triggers
Debugging with SQL Developer
Conditional compilation
Warnings
2. Advanced Cursors
Cursor parameters
Parameter defaults
Taking advantage of a weak cursor variable
OPEN FOR, FETCH, and CLOSE
Using the FOR UPDATE clause
Using PL/SQL collections and nested collections
3. Advanced Packages
Initializing variables
Module overloading
Recursion
Purity levels
Using the "Persistent Stateto advantage
One time only procedures
Forward declarations
Using Persistent State
Code encapsulation
Constant and exception standardization
4. Advanced Triggers