DYNAMIC SQL ADVANTAGES & disadvantages NATIVE dynamic sql DYNAMIC update…returning DYNAMIC sql using DBMS_SQL()

USING COLLECTIONS ABOUT collections BULK bind using collections COLLECTION methods MORE about the returning clause ADVANCED collection features COLLECTION multiset operations IN indices of clause IN values of clause

SYSTEM-SUPPLIED PACKAGES: DBMS_METADATA()-PART I WHY retrieve object definitions? RETRIEVING default metadata RETRIEVING customized metadata USING open() & close() USING set_filter() USING set_count() USING add_transform() USING fetch DDL() ABOUT sys.kus_ddl ABOUT sys.kus_ddls CALLING fetch_ddl()

SYSTEM-SUPPLIED PACKAGES: DBMS_METADATA()-PART II SET-transform_param() GET_query()

SYSTEM-SUPPLIED PACKAGES: DBMS_METADATA()-PART III FETCH clob() SET_filter() for dependent objects SET_parse_item() PRIMARY & dependent object DDL

SYSTEM-SUPPLIED PACKAGES: DBMS-REDFINTION() ABOUT table redefinition USING DBMS_redefinition () DBA_redefinition_errors CAN_redef_table() START_redef_table() FINISH_redef_table() ABORT_redef_table() COPY_table_dependents() SYNC-interim_table()

SYSTEM-SUPPLIED PACKAGES: DBMS-LOB() WORKING with external bfiles WORKING with internal LOBs LoadBLOBFromFile(), LoadCLOBFromFile() COMPARE() GETLENGTH() APPEND() COPY() ERASE() TRIM() READ() SUBSTR() INSTR() WRITE() DYNAMIC securefile options GETOPTIONS() SETOPTIONS()

SYSTEM-SUPPLIED PACKAGES: OTHERS COMPRESSION with UTL_compress() LZ-COMPRESS() LX(UNCOMPRESS() UTL_MAIL() SET SMTP_OUT_SERVER CALLING the send() procedure CALLING the send_attach_xxx() procedures DBMS_version() WAIT_on_pending_DML()

PL/SQL ADVANCED PROGRAMMING & CODING TECHNIQUES AUTONOMOUS transactions USING nocopy for parameters CHOOSING the optimum data type AVOIDING implicit data type conversion CHOOSING between number and pls_integer ABOUT pls_integer USING simple_integer CHAR variables of different lengths VARCHAR2 variables of different lenths CHAR vs VARCHAR2 CHAR vs WARCHAR2 with an equality comparison USEFUL pl/sql coding techniques HANDLING string literals

INFLUENCING ORACLE PL/SQL COMPILATION PL/SQL compiler optimization PLSQL_optimize-_level CONTROLLING compilation messages PL/SQL native execution

DYNAMIC PARTITIONING & PARALLELIZATION ABOUT dynamic portioning (chunks) CREATING & processing chunks CREATE_task() CREATE_chunks_by_rowid() CREATE_chunks_by_number_col() EXECUTE_run_task() TASK_status() DROP_task() MONITORING chunk processing

APPLICATION TUNING WITH THE PL/SQL HIERARCHICAL PROFILER WHAT is the hierarchical profiler? CONFIGURING the profiler MANAGING profiler runs ANALYZING profiler data INTERPRETING the results DBMSHP_RUNS DBMP_FUNCTION_INFO DBMP_PARENT_CHILD_INFO

PL/SQL DEBUGGING WITH DBMS_TRACE() USING the trace facility DBMS_TRACE() to manage runs EXAMINING the trace data EVENT_KIND values

PROTECTING AGAINST SQL INJETION ATTACKS UNDERSTANDING the threat APPLYING countermeasures

IMPLEMENTING VIRTUAL DATABASES UNDERSTANDING VPDS PREPARING for a VPD CONFIGURING a VPD MANAGING application contexts USING sys_context() MANAGING policies & security rules