Using the PL/SQL Debugger, Collections and Data Warehousing

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.