Oracle Database 11g: Using the PL/SQL Debugger, Collections, and Data Warehousing


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
To recognize ways to utilize the PL/SQL Debugger to analyze your code, identify the uses and benefits of collections, and identify the steps for employing data warehousing enhancements to improve query execution times.

Target Audience
PL/SQL developers, developers, system analysts, data warehouse administrators, and application developers

Prerequisites
The learner should have experience and knowledge of SQL and PL/SQL from prior Oracle releases, and hands on experience using PL/SQL

Expected Duration (hours)
1.2

Lesson Objectives

Oracle Database 11g: Using the PL/SQL Debugger, Collections, and Data Warehousing

  • identify the steps for using the PL/SQL Debugger tool in SQL Developer.
  • debug a procedure using the PL/SQL Debugger.
  • recognize the steps for making effective use of collections in PL/SQL and deciding which is the best collection to use in a given scenario.
  • recognize the steps for using materialized views and query rewrite enhancements to improve query execution times.

    • Course Number:
    257202_eng