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
Introduction to PL/SQL
- Overview of the PL/SQL runtime environment.
- Structure and types of PL/SQL blocks.
- Declaring and utilizing variables.
- Control structures: conditionals and loops.
Incorporating SQL within PL/SQL
- Executing DML commands.
- Utilizing DDL and dynamic SQL.
- Transaction control commands (TCL).
- Performing data retrieval with SELECT statements.
Procedures and Functions
- Creation and deletion of procedures and functions.
- Parameterization techniques.
- Passing parameters by value and by reference; understanding
NOCOPY.
Error and Exception Handling
- Strategies for managing errors and exceptions in PL/SQL.
Cursor Management
- Understanding records and static cursors.
- Parameterizing cursors.
- Implementing cursors with
FOR UPDATE.
Associative Arrays
- Declaring and using associative arrays in PL/SQL.
Packages
- Structure of packages: specifications and bodies.
- Initialization sections, global variables, and memory management.
- Concepts of encapsulation, overloading, and forward declarations.
Triggers
- Creating DML triggers.
- Implementing INSTEAD OF triggers.
- Understanding system triggers.
- Exploring advanced trigger features.
Practical Applications of Built-in Packages
- Writing to files using
UTL_FILE. - Sending emails from PL/SQL.
Code Management and Compilation
- Techniques for code encryption and obfuscation.
- Utilizing conditional compilation.
- Managing object dependencies.
- Interpreting compiler warnings.
Summary and Next Steps
Requirements
- Basic proficiency in any programming language (structured or object-oriented).
- Familiarity with SQL fundamentals and the Oracle database environment.
Audience
- Developers
- Database administrators
28 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.
