O'Reilly logo

Oracle Database 10g PL/SQL Programming by Michael McLaughlin, Ron Hardman, Scott Urman

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 10Database Triggers

The fourth type of named PL/SQL block is the trigger. Triggers share many of the same characteristics as subprograms (which we have examined in the previous two chapters), but they have significant differences both in how they are created and how they are called. In this chapter, we will examine how to create different types of triggers and discuss some possible applications.

Types of Triggers

Triggers are similar to procedures or functions in that they are named PL/SQL blocks with declarative, executable, and exception handling sections. Like packages and object types (which we will discuss in Chapters 1416), triggers must be stored as stand-alone objects in the database and cannot be local to a block or package. ...

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