Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Creating Stored Subroutines
- Compilation, object status, and source code management
- Code encryption (using WRAP)
- Understanding object dependency models
- Parameterization techniques
Permissions and Schemas in PL/SQL
- Owner and caller privilege models
- Direct privileges versus role-based permissions
- Implementation of whitelists
- Assigning roles to procedures and understanding permission inheritance
Advanced Cursors
- Comparing explicit cursors and cursor loops
- Utilizing pointers for weak and strong ref cursors
- Support for dynamic cursors
- Using FOR UPDATE cursors
Collections
- Understanding associative arrays (index-by), nested tables, and varrays
- Attributes, handling, initialization, and memory allocation
- Bulk processing using BULK COLLECT and bulk DML with FORALL
- Executing bulk operations within dynamic SQL
- Handling exceptions during bulk operations
- Utilizing array and stream functions
Packages
- Package structure: specifications versus bodies
- Advantages of using packages
- Initialization sections, global variables, memory management, and package instances
Triggers
- DML triggers
- View triggers (INSTEAD OF)
- System triggers
- Composite triggers
Application Context and VPD
- Utilizing built-in contexts
- Creating custom private and global contexts
- Saving and retrieving context values
- Implementing policies and Virtual Private Database (VPD)
Appendix A - Embedded Package Examples
- File handling (utl_file)
- Job scheduling (dbms_job and dbms_scheduler)
Suggested pre-training
ORA_S1, ORA_P1
Suggested complementary training
ORA_SP3
Requirements
Participants should have a solid understanding of SQL fundamentals, including queries, as well as DML, DDL, and TCL commands. Additionally, they must be able to interpret and write simple PL/SQL scripts.
21 Hours
Testimonials (3)
he explained very well, and gave guidance on the exercises.
Stoyan - OPEN COURSE
Course - Oracle Database 19c PL and Advanced SQL
I liked the hands-on experience and the opportunity to work on actual coding activities
Kristine - Isuzu Philippines Corporation
Course - ORACLE PL/SQL Fundamentals
The PL/SQL session basics. I used PL/SQL but never got the basics of it and this course helped me a lot understand PL/SQL queries.
