Curriculum
- 1 Section
- 17 Lessons
- 5 Days
Expand all sectionsCollapse all sections
- Topics17
- 1.1Advanced Programming: Why Needed & PL/SQL Execution Internals Why Advanced Programming? SQL & PL/SQL Execution Internals SQL & PL/SQL PGA Internals
- 1.2Advanced Programming: Dynamic SQL Advantages Of Dynamic SQL Native Dynamic SQL Dynamic SQL Using DBMS_SQL()
- 1.3Advanced Programming: Using Collections About Collections Bulk Bind Using Collections About SQL%BULK_ROWCOUNT() About SQL%BULK_EXCEPTIONS() Collection Methods More About RETURNING Clause Advanced Collection Features IN INDICES OF Clause IN VALUES OF Clause
- 1.4Advanced Programming: Java & C Interface Methods Advanced Program Interfaces Calling Java Classes Calling C Programs
- 1.5System-Supplied Packages: DBMS_METADATA() – Part I Why Retrieve Object Definitions? Retrieving Default Metadata Retrieving Customized Metadata Using SET_COUNT() Using ADD_TRANSFORM() Using FETCH DDL() Calling FETCH_DDL()
- 1.6System-Supplied Packages: DBMS_METADATA() – Part II SET_TRANSFORM_PARAM() GET_QUERY()
- 1.7System-Supplied Packages: DBMS_METADATA() – Part III FETCH CLOB() SET_FILTER() Dependent Objects SET_PARSE_ITEM() Primary & Dependent Object DDL
- 1.8System-Supplied Packages: DBMS_REDEFINITION() 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.9High-Performance: Advanced System-Supplied Packages COMPRESSION & UTL_COMPRESS() LZ_COMPRESS() LZ_UNCOMPRESS() DBMS_DESCRIBE() UTL_MAIL() DBMS_UTILITY() COMPILE_SCHEMA() DB_VERSION() GET_PARAMETER_VALUE() WAIT_ON_PENDING_DML() GET_TIME() GET_ENDIANNESS() DBMS_FILE_TRANSFER()
- 1.10High Performance: Programming & Coding Techniques Autonomous Transactions Using NOCOPY FOR Parameters Choosing The Optimum Data Type About NOT NULL Useful PL/SQL Coding Techniques Handling String Literals User-Defined SQL Functions
- 1.11High Performance: Influencing Oracle Pl/Sql Compilation PL/SQL Compiler Optimization PLSQL_OPTIMIZE_LEVEL Controlling Compilation Messages PL/SQL Native Execution Wrapping Source Code
- 1.12High Performance: Dynamic Partitioning & Parallelization Dynamic Partitioning (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.13High Performance: Using PL/SCOPE For Code Analysis Configuring PL/SCOPE PLSCOPE_SETTINGS Using PL/SCOPE Data
- 1.14High Performance: Tuning With The Hierarchical Profiler What Is The Hierarchical Profiler? Configuring The Profiler Managing Profiler Runs Analyzing Profiler Data Interpreting The Results DBMSHP_RUNS DBMSHP_FUNCTION_INFO DBMSHP_PARENT_CHILD_INFO
- 1.15High Performance: Debugging With DBMS_TRACE() Using The Trace Facility DBMS_TRACE() To Manage Runs Examining The Trace Data EVENT_KIND Values
- 1.16Application Security: SQL Injection Attacks Understanding The Threat Applying Countermeasures
- 1.17Application Security: Virtual Private Databases Understanding VPDS Preparing For A VPD Configuring A VPD Managing Application Contexts Managing Policies & Security Rules
High Performance: Tuning With The Hierarchical Profiler What Is The Hierarchical Profiler? Configuring The Profiler Managing Profiler Runs Analyzing Profiler Data Interpreting The Results DBMSHP_RUNS DBMSHP_FUNCTION_INFO DBMSHP_PARENT_CHILD_INFO
Prev
Application Security: SQL Injection Attacks Understanding The Threat Applying Countermeasures
Next