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

Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants

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

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.