Re: Future of Triggers

"ozi" <spuzic_at_camtech.net.au> wrote in message news:%oqK5.9246$SF5.185780_at_ozemail.com.au...
> The instead OF triggers require you to update through the view directly to
> fire the trigger. I was thinking more of when a TABLE is updated, all of the
> views over that table are checked and any trigger that is associated with it
> is fired.
>

I don't see that this functionality would be required, useful, or beneficial.

>
> "Matthew Fuller" <matthewlf_at_my-deja.com> wrote in message
> news:8tc40n$ll9$1_at_nnrp1.deja.com...
> > In article <1mfK5.9116$SF5.177933_at_ozemail.com.au>,
> > "ozi" <spuzic_at_camtech.net.au> wrote:
> > > Hi Everyone,
> > >
> > > Does anyone know if ORACLE are planning to introduce triggers for
 views. For
> > > example you would be able to set a trigger on the following SQL
 statement;
> > >
> > > SELECT * FROM EMP_TABLE
> > > WHERE EMP_SAL > 20000
> > >
> > > and whenever a row is inserted that matches this query, a trigger is
 fired.
> > >
> >
> > Tom,
> >
> > See documentation for "INSTEAD OF" triggers.
> >
> > Matt.
> > > Cheers,
> > > Tom
> > >
> > >
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
>
Received on Sat Oct 28 2000 - 20:38:04 CDT