Oracle Database 11g: Using Triggers and the PL/SQL Compiler

Overview/Description
To identify the steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warnings.

Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.

Prerequisites
Previous programming experience and knowledge of SQL

Expected Duration (hours)
2.0

Lesson Objectives

Oracle Database 11g: Using Triggers and the PL/SQL Compiler

identify the steps for creating and using database triggers.

recognize the steps for enabling, disabling, testing, managing, and removing database triggers.

identify the steps for creating and using compound, DDL, and event database triggers.

create statement and row triggers, including a trigger for a business rule and a package with triggers that resolve a mutating table issue.

recognize the benefits and capabilities of the PL/SQL compiler and its parameters.

recognize the steps for using the PL/SQL compiler initialization parameters, compiling a procedure, and managing compiler warnings.