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: Tue, 07 Aug 2001 01:19:27 GMT
Message-ID: <zmHb7.14001$DW1.2707949@news1.rdc1.mb.home.com>

Thank you

--


------------------------------------
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:a20d28ee.0108060109.5a970f07_at_posting.google.com...

> You don't receive them in a variable, they are pre-defined (boolean)
variables
> which are available in triggers only.
>
> Hth,
>
> Sybrand Bakker, Senior Oracle DBA
>
>
>
>
> "EMDI" <di.pasquale_at_home.com> wrote in message
news:<5Vpb7.12718$DW1.2382397_at_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 - 20:19:27 CDT

Original text of this message

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