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