Re: Trigger: How identify which event fire the trigger.?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 4 Aug 2001 06:16:35 +0200
Message-ID: <996898599.23642.0.pluto.d4ee154e@news.demon.nl>

"EMDI" <di.pasquale_at_home.com> wrote in message news:G4Ga7.8444$DW1.1483534_at_news1.rdc1.mb.home.com...
> Hi Guys.
> I need to generate a trigger with almost the same logic for Insert, UPdate
> and Delete however I need to know which event fire the trigger in order to
> adjust the code and avoid to create three triggers.
>
> Thanks
> ------------------------------------
> Make Unlimited phone calls from your PC to ANY phone in the World!
> http://www.eboom.com/free/
>
>

if inserting then
else if updating then
else

etc.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Fri Aug 03 2001 - 23:16:35 CDT