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.?
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...Received on Mon Aug 06 2001 - 20:19:27 CDT
> 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
> > >
> > >
> > >