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
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
Prev
SYSTEM-SUPPLIED PACKAGES: DBMS_METADATA()-PART II SET-transform_param() GET_query()
Next