This discussion is archived
4 Replies Latest reply: Dec 3, 2012 9:24 PM by Sachinmrt RSS

How to know Trigger event name

Sachinmrt Explorer
Currently Being Moderated
Dear all,

I have one question please tell me how to know the trigger event name in trigger calling...
like-
CREATE OR REPLACE TRIGGER ******
BEFORE DELETE OR INSERT OR UPDATE
OF TOTAL_QUANTITY,CANCELLED
ON *********
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
-----------I want to know given trigger event at this level-----------
  IF INSERTING  THEN
    null;
  ELSIF UPDATING  THEN
   null;
  ELSIF DELETING THEN
     null;
  END IF;

END;
Please help...

Edited by: Sachingmrt on Dec 3, 2012 1:05 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points