Re: Future of Triggers

From: Matthew Fuller <matthewlf_at_my-deja.com>
Date: Fri, 27 Oct 2000 14:38:16 GMT
Message-ID: <8tc40n$ll9$1@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 - 09:38:16 CDT