Workshop

Digicomp Code ODPLSA

Oracle PL/SQL – Advanced («ODPLSA»)

In this workshop, which is based on PL/SQL basics, more advanced functionalities are covered. The topics range from packages and triggers to PL/SQL arrays, pipelined table functions and bulk operations.
Duration 2 days
Price 2'150.–
Course documents Digicomp digital courseware
Register

Course facts

  • Gaining advanced knowledge of Oracle PL/SQL 
  • Gaining knowledge of packages and triggers
  • Gaining knowledge of PL/SQL arrays, pipelined table functions and bulk operations

1 Packages – Advantages, structure, overloading, package variables

2 REF Cursor – Purpose, Definition Strong versus Weak REF Cursor, SYS_REFCURSOR

3 PL/SQL Arrays – Purpose, types (real, associative, varrays and nested tables)

4 Dynamic SQL

  • Static versus Dynamic SQL
  • EXECUTE IMMEDIATE
  • DBMS_SQL

5 Some Oracle provided packages

  • DBMS_OUTPUT
  • UTL_FILE
  • DBMS_SCHEDULER
  • UTL_MAIL
  • DBMS_UTILITY
  • etc.

6 Trigger

  • Trigger types: DML, Instead-of, Logon, Database Event Trigger
  • Timing: BEFORE, AFTER, INSEAD OF
  • Level: STATEMENT or ROW
  • Mutating Table Trigger

7 Functions for advanced users

  • Records as return value
  • TABLE Operator
  • REF Cursor as parameter
  • Pipelined Table Functions

8 Bulk Operations – what is it and why should you use it?

The participants receive theoretical knowledge, which is consolidated with many practical exercises. 

This workshop is intended for prospective Oracle database administrators, Oracle developers or architects, generally anyone involved with Oracle SQL.

PL/SQL programming knowledge is required. Basic SQL knowledge is a prerequisite.

Download

Download course details as PDF

Questions

Choose your date