USING SQL DEVELOPER

·         PREPARING THE EXECUTION ENVIRONMENT

·         INSTALLING SQL DEVELOPER

·         BASIC CONNECTION TYPE

·         TNS CONNECTION TYPE

·         ADVANCED CONNECTION TYPE

·         MANAGING CONNECTIONS

·         EXECUTING EXTERNAL SCRIPTS

·         USING BIND VARIABLES FROM SQL DEVELOPER

USING THE DATABASE RESULT CACHE

·         CONFIGURING THE RESULT CACHE

·         USING THE RESULT CACHE

·         MANAGING & MONITORING THE RESULT CACHE

ORACLE BASICFILES & SECUREFILES

·         LOB CONCEPTS & TERMINOLOGY

·         BASICFILES LOB

·         TABLE DDL WITH LOBS

·         CONTROLLING LOB PHYSICAL STORAGE

·         INITIALIZE INTERNAL LOBS

·         INITIALIZE EXTERNAL LOBS

·         LOB COLUMNS & SQL

·         SECUREFILES LOBS

·         MIGRATING BASICFILES TO SECUREFILES

·         MONITORING SECUREFILES PERFORMANCE

DATABASE-RESIDENT PROGRAM UNIT ENHANCEMENTS

·         MIXED NOTATION PROCEDURE REFERENCES

·         CREATING DISABLED TRIGGERS

·         CONTROLLING THE ORDER OF TRIGGER EXECUTION

·         DEVELOPING COMPOUND TRIGGERS

·         EXPLOITING & MANAGING CURSOR SHARING

·         ABOUT CURSOR SHARING

·         BIND VARIABLES & CURSOR PEEKING

·         USING THE CURSOR_SHARING PARAMETER

·         DYNAMIC SQL

·         NATIVE DYNAMIC SQL

USING COLLECTIONS

·         ABOUT COLLECTIONS

·         BULK BIND USING COLLECTIONS

·         COLLECTION METHODS

RETRIEVING DDL WITH DBMS_METADATA()

·         WHY RETRIEVE OBJECT DEFINITIONS?

·         RETRIEVING DEFAULT METADATA

·         RETRIEVING CUSTOMIZED METADATA

ADVANCED DBMS_METADATA() PROCESSING

·         SET_TRANSFORM_PARAM()

·         GET_QUERY()

·         PROCESSING DEPENDENT OBJECTS WITH DBMS_METADATA()

REDEFINING TABLES WITH DBMS_REDEFINITION()

·         ABOUT TABLE REDEFINITION

·         USING THE DBMS_REDEFINITION() PACKAGE

·         USING OTHER SYSTEM-SUPPLIED PACKAGES

·         DBMS_DESCRIBE()

·         UTL_MAIL

·         DBMS_SCHEDULER()

ADVANCED INTERFACE METHODS

·         ABOUT EXTERNAL PROCEDURES

·         REGISTERING WITH THE DATABASE

·         ORACLE NET CONFIGURATION

·         CALLING EXTERNAL PROCEDURES

ABOUT PL/SQL PERFORMANCE TUNING

ABOUT THE TUNING EFFORT

·         THE DIFFICULTY OF TUNING

·         THE SQL & PL/SQL EXECUTION ENVIRONMENT

·         THE IMPACT OF THE SYSTEMS INFRASTRUCTURE

·         USING THE TUNING UTILITIES

INFLUENCING PL/SQL COMPILATION

·         PLSQL_WARNINGS

·         PLSQL_OPTIMIZE_LEVEL

·         PL/SQL NATIVE EXECUTION

·         PL/SQL TUNING WITH DBMS_PROFILER()

ABOUT DBMS_PROFILER()

·         INSTALLING DBMS_PROFILER()

·         USING DBMS_PROFILER() TO MANAGE RUNS

·         EXAMINING THE PROFILER TABLES

EVALUATING THE PL/SQL PROFILER DATA

·         ABOUT THE PROFILER DATA

·         USER QUERIES OF THE CROSS RUN TABLES

·         SYSTEM-SUPPLIED CROSS RUN TABLES QUERIES

PL/SQL ADVANCED PROGRAMMING & TUNING TECHNIQUES

·         AUTONOMOUS TRANSACTIONS

·         USING NOCOPY FOR PARAMETERS

·         CHOOSING THE OPTIMUM DATATYPE

·         USEFUL PL/SQL CODING TECHNIQUES

PL/SQL DEBUGGING WITH DBMS_TRACE()

·         ABOUT THE TRACE FACILITY

·         INSTALLING DBMS_TRACE()

·         USING DBMS_TRACE() TO MANAGE RUNS

·         EXAMINING THE PLSQL_TRACE_... TABLES

MISCELLANEOUS ENHANCEMENTS

·         SIMPLE_INTEGER

·         CONTINUE WHEN