Overview of PLSQL
Declaring PLSQL Variables
Writing executable statements
Interacting with Oracle DB Server
Writing Control structure
Working with Composite Data Types
Using explicit cursors
Handling Exceptions
Creating Procedure
Creating Functions
Working with Packages
Using oracle-supplied Packages in Application Development
Using Dynamic SQL
Design consideration for PLSQL Code
Triggers
Creating Compound, DDL, and Event Database Triggers
Using the PLSQL Compiler
Managing PLSQL Code
Managing Dependencies