sql - Materialized view with trigger? -


can create trigger on materialized view? i'm using oracle 10g.

yes, can. careful. oracle documentation says:

if create trigger on base table of materialized view, must ensure trigger not fire during refresh of materialized view. during refresh, dbms_mview procedure i_am_a_refresh returns true.


Comments

Popular posts from this blog

apache - Add omitted ? to URLs -

redirect - bbPress Forum - rewrite to wwww.mysite prohibits login -

php - How can I stop spam on my custom forum/blog? -