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 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.
