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

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

Prerequisite
Previous programming experience and knowledge of SQL

Expected Duration
120 minutes

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.

Objective

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.
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.