Overview/Description
To recognize the steps for improving SQL and PL/SQL flexibility, usability, and performance, using dynamic SQL, language enhancements, and a variety of performance enhancements
Target Audience
PL/SQL developers, developers, system analysts, data warehouse administrators, and application developers
Prerequisites
The learner should have experience and knowledge of SQL and PL/SQL from prior Oracle releases, and hands on experience using PL/SQL
Oracle Database 11g: Using Dynamic SQL and Implementing Performance Improvements
recognize the steps for using native dynamic SQL and the DBMS_SQL package to specify dynamic SQL statements, using CLOB data types and also abstract data types.
identify the steps for using language enhancements to improve sequence usability, control loop iterations, employ named and mixed notation in calls to PL/SQL, and place a table in read-only mode.
recognize the steps for improving the performance of SQL and PL/SQL with a new compiler, a new, faster data type, inlining for faster performance, caching, and flashback enhancements.
examine and then improve performance in Oracle Database 11g.