image
CHAPTER
12
Triggers
Database triggers are specialized stored programs. They are not called directly but are triggered by events in the database. They run between the time you issue a command and the time you perform the database management system action. This time interval is the transaction lifecycle. You can read more about the transaction lifecycle in the “Data Transactions” section of Appendix A. Appendix A also discusses ACID-compliant transactions and the two-phase commit (2PC) processes, in the section “Data Transactions.” Together, they support the Oracle Database implementation of MVCC.
Triggers on INSERT, UPDATE, and DELETE statements ...

Get Oracle Database 12c PL/SQL Programming now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.