Dallas-Ft Worth, TX
El Paso, TX
Kansas City, MO
Los Angeles, CA
|Pittsburgh, PA||08/26-08/28||Virtual Classroom||08/26-08/28||Kansas City, MO||08/26-08/28||Toronto, ON||08/26-08/28||Ottawa, ON||08/26-08/28||Sacramento, CA||08/26-08/28||Omaha, NE||08/26-08/28||San Francisco, CA||08/26-08/28||Calgary, AB||08/26-08/28||Vancouver, BC||08/26-08/28||Oklahoma City, OK||08/26-08/28||Tulsa, OK||08/26-08/28|
[ Select a date to register ]
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.
3 Days/Lecture & Lab
This course is designed for intermediate Oracle PL/SQL developers and DBAs.
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