| Introduction to PL/SQL |
Declaring PL/SQL Identifiers |
| Writing Executable Statements |
Interacting with the Oracle Server |
| Writing Control Structures |
Working with Composite Data Types |
| Using Explicit Cursors |
Handling Exceptions |
| Creating Stored Procedures |
Creating Stored Functions |
| Creating Packages |
Using More Package Concepts |
| Utilizing Oracle Supplied Packages in Application Development |
Dynamic SQL and Metadata |
| Design Considerations for PL/SQL Code |
Managing Dependencies |
| Manipulating Large Objects |
Creating Triggers |
| Applications for Triggers |
Understanding and Influencing the PL/SQL Compiler |