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

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
Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants

Prerequisites
The learner should have experience and knowledge with SQL, specifically the Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II learning

Expected Duration (hours)
2.0

Lesson Objectives

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

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.