Oracle Advanced PL/SQL

     This hands-on course provides critical continuation of learning for the PL/SQL developer and is the next step for students with knowledge of the PL/SQL basics. This class is designed for PL/SQL developers writing or supporting complex enterprise systems.

Topics Covered

  • PL/SQL review of Procedures, Functions, Packages, Database Triggers
  • Oracle PL/SQL new features overview
  • Working with object types and methods
  • PL/SQL records, tables and collections
  • Table functions
  • Reference Cursors
  • Overloading packages
  • Built-in packages
    • DBMS_SQL and execute immediate
    • DBMS_LOB
    • UTL_FILE
    • DBMS_JOB & DBMS_Scheduler


     Oracle application developers



     Students will expand their knowledge of basic Oracle PL/SQL and be able to incorporate user defined datatypes (objects, records, tables, collections) and built-in packages when developing complex enterprise systems.

Furnished Materials:

  • PC Workstation for use during training
  • Student Manual

Recommended Follow-On Course


  • 3 Days


  • $1,485

Training Dates:

Sign Up