PL/SQL allows developers to extend the basic data query and manipulation of SQL into complete applications and shared program units. This class provides the technical expertise necessary to utilize this powerful component of Oracle.
The content of this course applies to developing PL/SQL blocks for standalone use, stored procedures, functions, packages and triggers or in the Oracle Forms or Reports development tools.
One of the most powerful features of PL/SQL is the ability to create ‘program units’ that are stored within the database. This allows for robust solutions to be developed that can be shared and re-used. Students will learn to write, debug and manage all types of program units: procedures, functions, packages and triggers.
2 Days/Lecture & Lab
This course is designed for: