Re: Future of Triggers
From: Andrew Pahomow <Pahomov_at_validio.com.ua>
Date: Sat, 28 Oct 2000 16:34:59 +0200
Message-ID: <39fad683$1_at_miik2-ilt.ilt.kharkov.ua>
Date: Sat, 28 Oct 2000 16:34:59 +0200
Message-ID: <39fad683$1_at_miik2-ilt.ilt.kharkov.ua>
ozi <spuzic_at_camtech.net.au> wrote in message
news:oofK5.9117$SF5.177998_at_ozemail.com.au...
> 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.
>
> Cheers,
> Tom
>
>
See manual on INSTEAD OF TRIGGERS Received on Sat Oct 28 2000 - 16:34:59 CEST