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)
I liked very much the format of the training, hands on, directly in sql developer.
Andreea - OPEN COURSE
Course - Oracle Database 19c PL and Advanced SQL
The exercises were explained very good.
Monica - DB Global Technology
Course - PL/SQL in Oracle 19c
It was quite hands-on, not too much theory.
