4 Replies Latest reply: Dec 3, 2012 11:24 PM by Sachinmrt RSS

    How to know Trigger event name

    Sachinmrt
      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