PL/SQL Triggers

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

Overview

To create and manage triggers

Target Audience

Database administrators, application developers, and database operators

Prerequisites

Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases, the SQL programming language, and stored procedures; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata

Expected Duration

230 min.

Course Objectives

PL/SQL Triggers

  • identify the function, benefits, and enhancements provided by triggers in PL/SQL.
  • distinguish between DML row and statement triggers and the way that they execute and associate the main types of DML trigger timing with the instances in which each is used.
  • identify the differences between the features of database triggers and those of stored procedures and Oracle’s Forms triggers.
  • specify the code required to create a DML statement trigger for a given scenario.
  • specify the code required to create a DML row trigger and use a DML row trigger to implement an integrity constraint.
  • specify the code required to create an INSTEAD OF trigger.
  • create DML and INSTEAD OF triggers.
  • specify the code required to create a trigger on a DDL statement and a system event.
  • specify the code required to invoke a procedure in a trigger using a CALL statement and identify the rules that enable triggers to read and write data to a mutating table.
  • specify the code required to view trigger information and manage trigger code for a given scenario.
  • identify the best practices associated with testing trigger code.
  • create and manage triggers in a given scenario.
  • develop a suitable trigger for a given scenario.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?