One of the most powerful features of the Oracle RDBMS product is the ability to create named 'blocks' of PL/SQL code that are stored within the database. This allows for robust solutions to be developed that can be shared and re-used.
This intermediate class provides the technical expertise necessary to expand the powerful capabilities of PL/SQL by creating program units: stored procedures, functions, packages and triggers that are stored within the database. Working in Oracle's SQL Developer tool participants will learn how to develop, debug and manage all these types of programs.
The four types of these program units: procedures, functions, packages and triggers are each covered in depth. Students will learn to write, debug and manage each. Students use the Oracle PL/SQL IDE, SQL Developer, throughout the course as the presentation tool and as their development environment. Features of this tool that enhance productivity along with its integral source level debugger are presented.
3 Days/Lecture & Lab
This course is designed for Intermediate Oracle PL/SQL developers and DBAs supporting development tasks DBAs who want to automate repetitive database management tasks