Oracle PL/SQL Advanced

    

Summary:
This class covers advanced topics related to Oracle PL/SQL. This class provides the technical expertise necessary to utilize these powerful components of Oracle.Attention in this class is given to some aspects of PL/SQL that are often not clearly understood (collections and overloading) or fully utilized (default values for program units, package startup code) along with advanced topics such as autonomous transactions, REF cursors and bulk binding. Some of the newer features of PL/SQL (the MERGE and CASE statements) are introduced. Techniques for measuring PL/SQL performance and features to enhance the performance of PL/SQL are also presented.The functionality of a number of highly leverable Oracle supplied PL/SQL packages is covered.

Duration:
3 Days/Lecture & Lab

Audience:
This course is designed for intermediate Oracle PL/SQL developers and DBAs.

Topics:

• Oracle's SQL tools
• PetSaver sample data
• New Oracle features
• Working with block hierarchies
• Advanced exception handling
• Maintaining PL/SQL stored program units
• Advanced features of procedures and functions
• Advanced features of packages
• Advanced features of triggers
• Advanced cursor topics
• Oracle supplied packages, I
• PL/SQL composite variables
• Dynamic SQL
• Oracle supplied packages, II
• Working with large objects (LOBs)
• PL/SQL performance tuning

Prerequisites:
A solid understanding of PL/SQL, including the use of program units (procedures, functions, packages and triggers) is required to succeed in this class. Students planning to attend this class should attend the Oracle PL/SQL Programming class (PT6046) class which can be conducted on the day preceding this class. Students should also have skills with GUI Interfaces and a data processing background.

Last Update: May 24, 2013