Oracle PL/SQL - The course for advanced users
Triggers, dynamic SQL and advanced functions
.svg)
Machine Learning Engineer
1. Packages – Benefits, Structure, Overloading, Package Variables
2. REF Cursor – Purpose, Definition: Strong vs. Weak REF Cursor, SYS_REFCURSOR
3. PL/SQL Arrays - Purpose, Types (true arrays, associative arrays, varrays, and nested tables)
4. Dynamic SQL
- Static versus dynamic SQL
- EXECUTE IMMEDIATE
- DBMS_SQL
5. Some packages provided by Oracle
- 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. Advanced Features
- Records as a return value
- TABLE Operator
- REF Cursor as parameter
- Pipelined Table Functions
8. Bulk Operations – What Are They, and Why Should You Definitely Use Them?
Requirements:
You need PL/SQL programming skills. Basic knowledge of SQL is required.
- Advanced knowledge of Oracle PL/SQL
- Understanding packages and triggers
- Knowledge of PL/SQL arrays, pipelined table functions and bulk operations
This course consists of training training and is led by a trainer who supervises the participants live. Theory and practice are taught with live demonstrations and practical exercises. The video conferencing software Zoom is used.
This workshop is aimed at prospective Oracle database administrators, Oracle developers or architects, generally anyone who has to do with Oracle SQL. PL/SQL programming knowledge is required. Basic SQL knowledge is a prerequisite.
.svg)
