O'Reilly logo

Oracle Database 11g PL/SQL Programming Workbook by John M. Harper, Michael McLaughlin

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 9Triggers

Triggers are an excellent part of the Oracle Database feature set. They allow you to automate processes around the enforcement of security rules, maintain data integrity in distributed systems, audit database usage, create historical data trails, prevent harmful data transactions, and generate derived column values.

Unfortunately, we see their use in scenarios that they were never intended to fulfill. For example, some database professionals use triggers to perform check constraints. While they are able to do so, Oracle Database PL/SQL Language Reference 11g specifically states that users should “not define triggers that duplicate database features.”

This chapter will discuss the following methodologies on trigger design and ...

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