Part 2 of 4 in the Oracle & PL/SQL path

Advanced Learning Guide to PLSQL booklet cover

Advanced Learning Guide to PLSQL

PDF 787 KB Advanced Sep 2026

Take your PL/SQL beyond the basics with this advanced guide to Oracle's procedural language. Designed for developers who already write PL/SQL and want to master the techniques that make production code fast, robust, and maintainable.

What you'll learn

  • Write advanced PL/SQL with records, collections, and composite types
  • Speed up data processing with bulk binds
  • Build dynamic SQL safely with EXECUTE IMMEDIATE
  • Design robust packages, triggers, and error handling

Table of contents

  1. PL/SQL Architecture & Block Structure
  2. Records, Collections & Composite Types
  3. Advanced Cursor Techniques
  4. Bulk Binds: FORALL & BULK COLLECT
  5. Dynamic SQL with EXECUTE IMMEDIATE
  6. Stored Procedures & Functions In Depth
  7. Packages: Specs, Bodies & State
  8. Compound & System Triggers
  9. Autonomous Transactions
  10. Exception Handling Strategies
  11. Performance Tuning for PL/SQL
  12. Real-World Patterns & Best Practices