WA1384 Oracle Database 10g: New & Advanced Features For Developers Course Outline   1. ORACLE FLASHBACK TECHNOLOGY ABOUT FLASHBACK TECHNOLOGY FLASHBACK QUERY FLASHBACK TABLE FLASHBACK DROP FLASHBACK VERSIONS QUERY FLASHBACK TRANSACTION QUERY Querying FLASHBACK_TRANSACTION_QUERY GUARANTEE UNDO RETENTION 2. MANAGING DATA: EXPORTING & IMPORTING DATA CREATE DIRECTORY OBJECTS ABOUT THE DATA PUMP ARCHITECTURE DATA PUMP EXPORT DATA PUMP IMPORT DATA PUMP DATA DICTIONARY VIEWS USING THE EM INTERFACE 3. INDEXES WITHIN THE APPLICATION SCHEMA B-TREE INDEXES FUNCTION-BASED INDEXES COMPRESSED INDEXES REVERSE-KEY INDEXES BITMAP INDEXES BITMAP JOIN INDEXES LINGUISTIC INDEXES ACCESSING INDEX OBJECTS USING THE EM INTERFACE 4. ADVANCED TABLES: CLUSTERS & IOTS ABOUT INDEX CLUSTERS ABOUT HASH CLUSTERS ABOUT INDEX-ORGANIZED TABLES 5.ADVANCED TABLES: EXTERNAL TABLES ABOUT EXTERNAL TABLES ORACLE_LOADER ACCESS PARAMETERS RECORDS Parameter BADFILE Parameter LOGFILE Parameter DISCARDFILE Parameter LOAD WHEN Parameter SKIP Parameter The LOCATION Clause REJECT LIMIT Clause FIELDS TERMINATED BY Parameter MISSING FIELD VALUES Parameter ORACLE_DATAPUMP ACCESS DRIVER VIEWING & ALTERING PROPERTIES OF EXTERNAL TABLES USER_EXTERNAL_TABLES USER_EXTERNAL_LOCATIONS Using ALTER TABLE 6.ADVANCED TABLES: TEMPORARY & COMPRESSED TABLES 7. PROCESSING HIERARCHIES WHY WE NEED HIERARCHIES PROCESSING 1:N HIERARCHIES PROCESSING M:N HIERARCHIES BOM Data Model ADVANCED HIERARCHY PROCESSING CONNECT_BY_ROOT() CONNECT_BY_ISLEAF 8. SQL NEW & ADVANCED FEATURES ASYNCHRONOUS COMMIT OPTIONS HANDLING DML ERRORS REGULAR EXPRESSIONS COLUMN ENCRYPTION MISCELLANEOUS ENHANCEMENTS 9. PL/SQL NEW & ADVANCED FEATURES HANDLING STRING LITERALS DATABASE TRIGGER ENHANCEMENTS COMPRESSION WITH UTL_COMPRESS() LZ_COMPRESS() LZ_UNCOMPRESS() COLLECTION ENHANCEMENTS MISCELLANEOUS ENHANCEMENTS 10. INFLUENCING ORACLE10G PL/SQL COMPILATION PLSQL_WARNINGS PLSQL_OPTIMIZE_LEVEL PL/SQL NATIVE EXECUTION