Programming with Advanced PL/SQL

Catalog description

This course covers advanced PL/SQL concepts. Students learn to create PL/SQL blocks of application code that can be shared by multiple forms; create reports and data management applications; create anonymous PL/SQL blocks; work with stored procedures and functions; declare variables; trap exceptions; and declare and control cursors. In addition, students learn to develop, execute, and manage PL\SQL stored program units such as procedures, functions, packages, and database triggers. They also learn to manage object dependencies and the recompilation of invalid objects. This course also describes the characteristics and techniques of the manipulation of large objects. Students are introduced to the uses of some of the Oracle-supplied packages. This is one of three Oracle certification training courses.