Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Trigger self inspection (am I inserting or updating?)
Hi. Given an 'AFTER INSERT OR UPDATE' trigger, is it possible within the trigger body, to determine whether it's been triggered by an insert operation, or an update operation?
I could create 2 triggers, but they are rather large triggers and the update trigger has only 1 line that does not appear in the insert trigger.
Thanks,
Morten Received on Wed Aug 14 2002 - 07:41:27 CDT