Using Trigger, Data Warehousing, and Pivoting Enhancements

Overview/Description
To recognize the steps for improving performance, managing scalabilty, enhancing control and processing speed, and reducing network load using enhanced features such as compound triggers, SecureFile LOBs, and PIVOT operations

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.3

Lesson Objectives

Oracle Database 11g: Using Trigger, Data Warehousing, and Pivoting Enhancements

identify the steps for creating and enabling a compound trigger and control its firing order using new trigger clauses.

recognize the steps for implementing SecureFile LOBs.

recognize the steps for performing PIVOT and UNPIVOT operations in various ways on the server side.

create reports with the PIVOT operator.