Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger: How identify which event fire the trigger.?
That is exactly what I want. Could you please tell me in wich variable I receive "Inserting", "Updating" and "Deleting". Thanks
-- ------------------------------------ Make Unlimited phone calls from your PC to ANY phone in the World! http://www.eboom.com/free/ "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:996898599.23642.0.pluto.d4ee154e_at_news.demon.nl...Received on Mon Aug 06 2001 - 00:27:29 CDT
>
> "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
>
>
>