In Oracle, you can define procedures that are implicitly executed when an INSERT, UPDATE or DELETE statement is issued against the associated table. These procedures are called database triggers.
There are six CREATE TRIGGER statements according to their firing points.
Firing Point: BEFORE
- BEFORE INSERT TRIGGER
- BEFORE UPDATE TRIGGER
- BEFORE DELETE TRIGGER
Firing Point: AFTER
- AFTER INSERT TRIGGER
- AFTER UPDATE TRIGGER
- AFTER DELETE TRIGGER
Leave a Reply