Oracle Trigger

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

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

Trigger Topics

1) Oracle BEFORE INSERT/UPDATE/DELETE Trigger

2) Oracle AFTER INSERT/UPDATE/DELETE Trigger

3) Oracle DROP Trigger

4) Oracle DISABLE Trigger

5) Oracle ENABLE Trigger