Learn Oracle PL/SQL — Procedural Programming for the Database

PL/SQL is Oracle's procedural extension to SQL — the language behind every stored procedure, function, package, and trigger in an Oracle Database. This free interactive tutorial covers everything you need to write production-grade PL/SQL and to pass the Oracle 1Z0-149 certification.

Each topic uses small, focused examples on the Oracle HR schema, followed by practice exercises and a quick quiz. The track runs from PL/SQL Basics through to packages, exception handling, bulk operations, and dynamic SQL — with detours into common interview topics.

What you'll learn in this PL/SQL tutorial

• PL/SQL block structure, variables, and control flow
• Cursors — implicit, explicit, REF cursors, and FOR loops
• Procedures, functions, and packages
• Triggers — DML, INSTEAD OF, compound, and DDL
• Exception handling and the PRAGMA EXCEPTION_INIT pattern
• Bulk collect, FORALL, and dynamic SQL with EXECUTE IMMEDIATE