Looping techniques: Simple LOOP, WHILE, FOR and nested loops
Executing SQL statements within PL/SQL blocks
Composite data types and collections
Module 3 — Cursor Management
Implicit & explicit cursors and cursor attributes
Parameterized cursors, cursors with loops and nested cursors
Cursors with subqueries and REF cursors
Records and PL/SQL table types
Module 4 — Advanced PL/SQL Programming
Creating and managing stored procedures
IN, OUT and IN OUT parameters
Positional and named notation; procedures using cursors
Modifying and dropping procedures
Module 5 — Functions in PL/SQL
User-defined functions and nested functions
Differences between procedures and functions
Using stored functions in SQL statements
Module 6 — Packages
Package specifications and bodies
Public and private package objects
Best practices for package development
Module 7 — Exception Handling
Predefined and user-defined exceptions
RAISE_APPLICATION_ERROR and PRAGMA AUTONOMOUS_TRANSACTION
Understanding SQL error codes and messages
Module 8 — Database Triggers
Types of triggers; row-level and statement-level triggers
DDL triggers and trigger-based auditing techniques
Course Outcome
By the end of this training, participants will be able to design, develop, debug and optimize PL/SQL programs, manage database objects efficiently, and build enterprise-grade database applications.
