Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Chapter 9. Triggers

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 11 g specifically states that users should “not define triggers that duplicate database features.”

This chapter will discuss the following methodologies on trigger design and implementation:


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint