Published by : Obay Salah , December 3, 2024

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


Tags : SQL

You May Also Like

Comments

no comment yet!