O'Reilly logo

Oracle by Elena Silvestrova Rakhimov, Benjamin Rosenzweig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 13 Triggers

Chapter Objectives

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.

Lab 13.1 What Triggers Are

Lab Objectives

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required