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
Share this Page URL
Help

PART II SQL Development > CHAPTER 15 Triggers

image

image

atabase triggers are specialized stored programs. They’re never called directly because they’re called indirectly by Data Definition Language (DDL) or Data Manipulation Language (DML) statements. The call is indirect because triggers wait in the background, listening for events, such as DDL or DML statements. When the events occur, they fire (call) triggers. Beyond DDL and DML statements, Oracle Database 11g also supports instead-of triggers for non-updateable views and system or database event triggers. On the other hand, MySQL supports DML statement triggers only for the INSERT, UPDATE, and DELETE statements.

This chapter covers the following:

image   Trigger architecture

image   DDL triggers

image   DML triggers

image   Compound triggers

image   Instead-of triggers


  

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