USING ISQL*PLUS • USING ISQL*PLUS • CONFIGURING ISQL*PLUS

ADVANCED SQL LANGUAGE CONSTRUCTS • CASE STATEMENT WITHIN PL/SQL • CASE EXPRESSION WITHIN SQL • COALESCE() FUNCTION

RETRIEVING DDL WITH DBMS_METADATA() • WHY RETRIEVE OBJECT DEFINITIONS? • RETRIEVING DEFAULT METADATA • RETRIEVING CUSTOMIZED METADATA

ADVANCED DBMS_METADATA() PROCESSING

PROCESSING DEPENDENT OBJECTS WITH DBMS_METADATA() • RETRIEVING PRIMARY & DEPENDENT OBJECT DDL

REDEFINING TABLES WITH DBMS_REDEFINITION() • USING THE DBMS_REDEFINITION() PACKAGE

DATA WAREHOUSING FEATURES (EXTERNAL TABLES) • ABOUT EXTERNAL TABLES • CREATING & ACCESSING EXTERNAL TABLES • PERFORMANCE CONSIDERATIONS • VIEWING & ALTERING PROPERTIES OF EXTERNAL TABLES

DATA WAREHOUSING FEATURES (TABLE FUNCTIONS) • IMPLEMENTING A PIPELINED TABLE FUNCTION

DATA WAREHOUSING FEATURES (ANALYTIC FUNCTIONS) • UNDERSTANDING ANALYTIC FUNCTIONS • USING RANKING AND BANDING FUNCTIONS • USING WINDOWING FUNCTIONS • USING LAGGING AND LEADING FUNCTIONS • USING REPORTING AGGREGATES

COMPLEX SQL OPERATIONS • USING MULTI-TABLE INSERT METHODS • USING THE MERGE STATEMENT • USING ANSI STANDARD JOINS • USING NAMED SUBQUERIES

SQL STATEMENT TUNING • ABOUT ENHANCED SQL STATEMENT TUNING • FIRST_ROWS • ORACLE9I SQL TUNING HINTS • CURSOR PEEKING & CURSOR SHARING • MONITORING INDEX USAGE

EDITING PRIVATE OUTLINES • ABOUT EDITING PRIVATE OUTLINES • PREPARING FOR PRIVATE OUTLINES • CREATING PRIVATE OUTLINES • EDITING PRIVATE OUTLINES • UTILIZING PRIVATE OUTLINES

COLLECTING SYSTEM STATISTICS • MANAGING SYSTEM STATISTICS

FLASHBACK QUERY • IMPLEMENTING FLASHBACK QUERY • ABOUT THE DBMS_FLASHBACK() PACKAGE • USING THE DBMS_FLASHBACK() PACKAGE

WORKSPACE MANAGER • WORKSPACE OPERATIONS • HANDLING CONFLICT RESOLUTION • UTILIZING SAVEPOINTS • SESSION INFORMATION & DDL OPERATIONS • A COMPLETE WORKSPACE MANAGER SCENARIO

INVOKING EXTERNAL FEATURES