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.
- Acquiring advanced knowledge of Oracle PL/SQL
- Learning about packages and triggers
- Gaining 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 intended for aspiring Oracle database administrators,developers architects—and, more generally, anyone who works with Oracle SQL.
.svg)
