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

jQuery clickable div with working mailto link inside -

java - Getting corefrences with Standard corenlp package -

WPF: binding viewmodel property of type DateTime to Calendar inside ItemsControl -