Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Triggers on Views fire for table?
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?
-- Luch replace nospam with usa for e-mail.Received on Mon Dec 03 2001 - 21:45:13 CST