Re: Triggers on Views fire for table?

In article <dFXO7.26383$WC1.2733755_at_newsread2.prod.itd.earthlink.net>, "Luch" says...
>
>I have table t_table with view v_view on it (create view v_view as select *
>from t_table;)
>
>What I want is to place a trigger on the view v_view, so that when an insert
>or upate is done into t_table the trigger fires. Is this possible? The
>reason I ask is because I only have access to the v_view, and I don't even
>know (or have rights) to what table it's coming from.
>
>When I try placing a trigger on v_view, it only fires if an insert/update is
>done "through" the view itself, but not the table. Is this the only way
>triggers on views work?
>

yes, triggers only fire on the object upon which they are defined.

A trigger on a view fires if and only if you insert/update/delete the view. Triggers on tables only fire when you modify the table.

>--
>Luch
>replace nospam with usa for e-mail.
>
>
>
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp