Workshop
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
Course facts
Key Learnings
- 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
Content
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?
Methodology & didactics
The participants receive theoretical knowledge, which is consolidated with many practical exercises.
Target audience
This workshop is intended for prospective Oracle database administrators, Oracle developers or architects, generally anyone involved with Oracle SQL.
Requirements
PL/SQL programming knowledge is required. Basic SQL knowledge is a prerequisite.
Download
Questions
We currently do not have any dates scheduled.
But we can arrange one for you. We will be happy to advise you individually on your course planning.
Contact us