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


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



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.
  • Course Number:
    260275_eng