To create and manage triggers
Database administrators, application developers, and database operators
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 (hours)
Lesson 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.