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 usage in the database.
After completing this lab, you will be able to
• Understand what a trigger is
• Use BEFORE and AFTER triggers
A database trigger is a named PL/SQL block stored in a database and executed implicitly when a triggering event occurs. ...