Curriculum
- 1 Section
- 16 Lessons
- 5 Days
Expand all sectionsCollapse all sections
- Topics16
- 1.1DYNAMIC SQL ADVANTAGES & disadvantages NATIVE dynamic sql DYNAMIC update…returning DYNAMIC sql using DBMS_SQL()
- 1.2USING 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
- 1.3SYSTEM-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()
- 1.4SYSTEM-SUPPLIED PACKAGES: DBMS_METADATA()-PART II SET-transform_param() GET_query()
- 1.5SYSTEM-SUPPLIED PACKAGES: DBMS_METADATA()-PART III FETCH clob() SET_filter() for dependent objects SET_parse_item() PRIMARY & dependent object DDL
- 1.6SYSTEM-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()
- 1.7SYSTEM-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()
- 1.8SYSTEM-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()
- 1.9ADVANCED INTERFACE METHODS ABOUT external procedures CALLING java classes CALLING programs
- 1.10PL/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
- 1.11INFLUENCING ORACLE PL/SQL COMPILATION PL/SQL compiler optimization PLSQL_optimize-_level CONTROLLING compilation messages PL/SQL native execution
- 1.12DYNAMIC 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
- 1.13APPLICATION 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
- 1.14PL/SQL DEBUGGING WITH DBMS_TRACE() USING the trace facility DBMS_TRACE() to manage runs EXAMINING the trace data EVENT_KIND values
- 1.15PROTECTING AGAINST SQL INJETION ATTACKS UNDERSTANDING the threat APPLYING countermeasures
- 1.16IMPLEMENTING VIRTUAL DATABASES UNDERSTANDING VPDS PREPARING for a VPD CONFIGURING a VPD MANAGING application contexts USING sys_context() MANAGING policies & security rules