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 the WRAP utility
- Understanding object dependency models
- Parameterization techniques
Permissions and Schemas in PL/SQL
- Owner's rights versus definer's rights execution models
- Direct permissions versus role-based permissions
- Privilege whitelists
- Assigning roles to procedures and inheritance of permissions
Advanced Cursors
- Comparing explicit cursors with cursor FOR loops
- Managing weak and strong REF cursor variables
- Support for dynamic cursors
- Using FOR UPDATE cursors
Collections
- Working with Associative Arrays (index by), nested tables, and varrays
- Attributes, manipulation, initialization, and memory allocation
- Performing bulk queries (BULK COLLECT) and bulk DML operations (FORALL)
- Executing bulk operations within dynamic SQL
- Handling exceptions during bulk operations
- Utilizing array and stream functions
Packages
- Package architecture: specifications versus bodies
- Advantages of utilizing 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
- Leveraging built-in system contexts
- Creating custom private and global contexts
- Storing and retrieving context values
- Implementing policies and Virtual Private Database (VPD)
Appendix A - Examples of Embedded Package Usage
- File handling using UTL_FILE
- Job scheduling with DBMS_JOB and DBMS_SCHEDULER
Recommended pre-training
ORA_S1, ORA_P1
Recommended complementary training
ORA_SP3
Requirements
A solid grasp of SQL basics, including querying techniques, as well as proficiency with DML, DDL, and TCL commands. Additionally, participants must be able to interpret and write basic 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.
