User Tools

Site Tools


kurs:materialized_views
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

refresh:

exec dbms_mview.refresh('emp_dep_mv', 'C');
kurs/materialized_views.txt · Last modified: 2014/09/10 21:22 (external edit)