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
Developing Stored Subroutines
- Compilation, object status, and source code management
- Code encryption (wrapping)
- Understanding object dependencies
- Parameterization techniques
Permissions and Schemas in PL/SQL
- Definer versus invoker rights models
- Direct permissions and roles
- Access control lists
- Assigning roles to procedures and permission inheritance
Advanced Cursor Techniques
- Comparing explicit cursors and cursor loops
- Managing weak and strong cursor types
- Dynamic cursor support
- Utilizing FOR UPDATE cursors
Collections
- Associative arrays (index by), nested tables, and VARRAYs
- Attributes, manipulation, initialization, and memory allocation
- Bulk operations: BULK COLLECT and FORALL
- Bulk processing in dynamic SQL
- Exception handling within bulk operations
- Array and string functions
Packages
- Package structure: specification and body
- 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
- Leveraging built-in contexts
- Creating custom private and global contexts
- Storing and retrieving context values
- Policies and Virtual Private Database
Appendix A - Embedded Package Examples
- File I/O operations (utl_file)
- Job scheduling (dbms_job and dbms_scheduler)
Recommended Pre-training
ORA_S1, ORA_P1
Recommended Supplementary Training
ORA_SP3
Requirements
Proficiency in SQL basics, including queries, DML, DDL, and TCL commands, along with the ability 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.
