Re: Future of Triggers

> 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.

This is out of the common trigger philosophy.

What I'd do is a trigger BEFORE/AFTER INSERT that would do :

IF :NEW.EMP_SAL > 20000 THEN
    FireMyPLSQLProcedure;
END IF; You will have the same result.

A.G. Received on Fri Oct 27 2000 - 09:51:49 CDT