Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger: How identify which event fire the trigger.?

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

From: EMDI <di.pasquale_at_home.com>
Date: Mon, 06 Aug 2001 05:27:29 GMT
Message-ID: <5Vpb7.12718$DW1.2382397@news1.rdc1.mb.home.com>

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...

>
> "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 Mon Aug 06 2001 - 00:27:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US