Re: Future of Triggers

From: ozi <spuzic_at_camtech.net.au>
Date: Sat, 28 Oct 2000 11:29:34 +0930
Message-ID: <%oqK5.9246$SF5.185780@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.

"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 Fri Oct 27 2000 - 20:59:34 CDT