Differences

This shows you the differences between two versions of the page.

--- kurs:materialized_views [2014/09/10 21:22]
+++ kurs:materialized_views [2014/09/10 21:22] (current)
@@ Line 1: / Line 1: @@
+<code>
+CREATE MATERIALIZED VIEW "HR"."EMP_DEP_MV"
+REFRESH COMPLETE ON DEMAND ENABLE QUERY REWRITE
+AS select first_name, last_name, salary from
+hr.departments d, hr.employees e
+where e.department_id = d.department_id
+</code>
+refresh:
+<code>
+exec dbms_mview.refresh('emp_dep_mv', 'C');
+</code>

dokuwiki