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

This course is included in our On-demand training solution.

Overview

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

120 min.

Course 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.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?