Oracle PL/SQL by Example, 6th Edition

13

Triggers

In this chapter, you will learn about

• What Triggers Are

• Types of Triggers

In Chapter 1, “PL/SQL Concepts,” you encountered the concept of named PL/SQL blocks such as procedures, functions, and packages that can be stored in the database. In this chapter, you will learn about another type of named PL/SQL block called a database trigger. You will also learn about different characteristics of triggers and their use in the database.

Lab 13.1: What Triggers Are

After this lab, you will be able to

• Define a Database Trigger

• Use BEFORE Triggers

• Use AFTER Triggers

• Employ Autonomous Transactions

Database Trigger

A database trigger is a named PL/SQL block that is stored in a database and executed implicitly when a triggering event ...