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 ...
Get Oracle Database 11g PL/SQL Programming Workbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
