Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to know Trigger event name

SachinmrtDec 3 2012 — edited Dec 4 2012

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 1 2013
Added on Dec 3 2012
4 comments
224 views