TRIGGER in Oracle

ORACLE TRIGGER

The database TRIGGERS are the procedures defined in the Oracle. When an INSERT, UPDATE or DELETE statement is issued these triggers can be implicitly executed. On the basis of the Firing Points, six CREATE TRIGGER statements can be defined.

 

BEFORE — Firing Point:

  • BEFORE INSERT TRIGGER
  • BEFORE UPDATE TRIGGER
  • BEFORE DELETE TRIGGER

 

AFTER — Firing Point:

  • AFTER INSERT TRIGGER
  • AFTER UPDATE TRIGGER
  • AFTER DELETE TRIGGER