Topic summary

• Deprecated Features and Replacements
  • Deprecated Features
  • LONG, LONG RAW Data Types
  • ANALYZE Command
  • Export / Import INCREMENTAL Functionality
  • Summary
• Flashback Query
  • Concepts
  • Using DBMS_FLASHBACK
  • Release 2 Statement-Level Flashback
  • Flashback Tips
  • Flashback Limitations
  • Summary
• External Tables
  • Concepts
  • Implementation and Use
  • Use for Querying External Files
  • Use for Loading Data
  • External Table Tips
  • Limitations
  • Summary
• Oracle9i SQL Features
  • MERGE Statement
  • Multi-Table INSERT Statement
  • ANSI Compliant Joins
  • Subquery Factoring
  • CONNECT BY Extensions
  • New Functions
  • 8i CASE Expression
  • Enhanced LOB Support
  • INSERT & UPDATE DEFAULT Value
  • Enhanced RENAME Support
  • User-Defined Aggregates
  • Analytic Functions
  • Resources
  • Summary
• Oracle9i PL/SQL Features
  • ANSI CASE Statement
  • Associative Arrays
  • Record-Based DML
  • Multi-Level Collections
  • Pipelined Functions
  • Native Compilation
  • LOB Support
  • Accessing metadata with DBMS_METADATA
  • UTL_FILE Improvements
  • Inheritance and Type Evolution Support
  • Triggering Statement Access
  • Did you see the following cool Oracle8i Features?
  • 8i Invoker Rights
  • 8i Bulk Binds
  • 8i Autonomous Transactions
  • 8i Database Event Triggers
  • Summary
• New Datatypes
  • Introduction to 9i Datetime Data
  • TIMESTAMP Datatype
  • TIMESTAMP WITH TIME ZONE Datatype
  • TIME STAMP WITH LOCAL TIME ZONE Datatype
  • Datetime Conversions
  • Time Zone Functions
  • INTERVAL Datatypes
  • Summary
• XML Support
  • Introduction to XML DB
  • XMLType Datatype
  • Using XMLType
  • Inserting XML Data into XMLType
  • Extracting XML Data from XMLType
  • Using XMLType within PL/SQL
  • Other XML Features
  • Summary
• Resumable Space Management
  • Introduction to Resumable Space Management
  • Errors Handled
  • Enabling RSM
  • Monitoring RSM
  • AFTER SUSPEND Trigger
  • Import and SQL*Loader Support
  • RSM Restrictions
  • Summary
• Security for Developers
  • 8i Fine Grained Access Control (FCAG) Review
  • 9i FGAC Enhancements
  • n-Tier Proxy Authentication
  • Fine-Grained Auditing
  • Other 9i Security Features
  • Summary
•   Index Enhancements for Developers
  • Bitmap Join Indexes
  • Index Monitoring - Finding Unused Indexes
  • Index Skip Scan Access Path
  • IOTs and Bitmap Indexes
  • The KEEP INDEX Option
  • Creating Indexes on a Constraint Clause
  • Summary
• Tuning Enhancements for Developers
  • Runtime Plan & Statistics
  • V$SQL_PLAN and V$SQL_PLAN_STATISTICS
  • Dynamic Sampling
  • Cursor Sharing
  • Forced Rewrite
  • Index Skip Scan Access Path
  • Compressed Tables
  • FIRST_ROWS_n Optimization
  • Miscellaneous Enhancements
  • Summary