Oracle PL/SQL Scripting & Automation

← Back to Courses
Oracle PL/SQL Scripting & Automation

Category: Database

Duration: 40-45 Hrs

Develop robust applications. Automate with precision. Master data integrity.


Prequisite : Oracle SQL.


This hands-on course introduces learners to Oracle PL/SQL (Procedural Language/SQL)—a powerful extension of SQL used to build secure, efficient, and automated database applications. Learners will gain the skills to write procedures, manage transactions, and build logic-driven solutions that go far beyond basic querying.

Course Modules

Description:

  • Understand PL/SQL’s role in Oracle
  • Explore block structure and syntax

Skills Learned:

  • Anonymous blocks
  • DECLARE, BEGIN, EXCEPTION
  • PL/SQL vs SQL

Description:

Declare and use variables in PL/SQL blocks

Skills Learned:

DECLARE, assignment operators

Scalar and composite types

%TYPE and %ROWTYPE

Description:

Write conditional logic and loops

Skills Learned:

IF...THEN...ELSE

CASE statements

FOR, WHILE, LOOP

Description:

Retrieve data row-by-row using cursors

Skills Learned:

  • Explicit and implicit cursors
  • Cursor FOR loops
  • Cursor attributes

Description:

Handle errors gracefully in PL/SQL

Skills Learned:

  • EXCEPTION block
  • Predefined and user-defined exceptions
  • Error logging

Description:

Create modular, reusable code blocks

Skills Learned:

  • CREATE PROCEDURE, CREATE FUNCTION
  • IN, OUT, IN OUT parameters
  • RETURN statements

Description:

Group related procedures and functions

Skills Learned:

PACKAGE and PACKAGE BODY

Encapsulation and modularity

Public vs private elements

Description:

Automate actions based on data changes

Skills Learned:

  • BEFORE, AFTER, INSTEAD OF triggers
  • Row-level and statement-level triggers
  • Auditing and enforcement

Description:

Improve performance with bulk processing

Skills Learned:

  • BULK COLLECT
  • FORALL
  • Performance tuning

Description:

Build a complete PL/SQL solution (e.g., automated order processing or budget tracker)

Skills Learned:

  • End-to-end PL/SQL scripting
  • Error handling and optimization
  • Delivering a functional solution