Back to Courses

PL/SQL

Learn Oracle PL/SQL programming. Master procedures, functions, triggers, and packages.

2 Weeks
7 Modules

Course Curriculum

Module 1: PL/SQL Basics

  • Introduction to PL/SQL
  • PL/SQL Block Structure
  • Variables & Data Types
  • Operators
  • Control Structures

Module 2: Cursors

  • Implicit Cursors
  • Explicit Cursors
  • Cursor Attributes
  • Cursor FOR Loop
  • REF Cursors

Module 3: Exception Handling

  • Predefined Exceptions
  • User-Defined Exceptions
  • RAISE Statement
  • PRAGMA EXCEPTION_INIT
  • Exception Propagation

Module 4: Procedures & Functions

  • Creating Procedures
  • IN, OUT, IN OUT Parameters
  • Creating Functions
  • Return Types
  • Debugging

Module 5: Packages

  • Package Specification
  • Package Body
  • Public & Private Elements
  • Package Initialization
  • Overloading

Module 6: Triggers

  • DML Triggers
  • DDL Triggers
  • INSTEAD OF Triggers
  • Compound Triggers
  • Trigger Best Practices

Module 7: Collections & Records

  • Nested Tables
  • VARRAYs
  • Associative Arrays
  • Records
  • Bulk Operations