Oracle Database 11g: Using Dynamic SQL and Implementing Performance Improvements


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



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

Expected Duration (hours)
1.3

Lesson Objectives

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.
  • Course Number:
    257188_eng