Re: materialized view execution

Posted by Arsalan on Dec 03, 2016; 5:20am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/materialized-view-execution-tp1648p1650.html


Sir

You just edit on script  i want to out put like this


------- i want output like below to refresh the materialized view

execute dbms_mview.refresh( list => 'BONUS', method => 'F' );


--but it give output like below please, so i can't concatenate tablename like  'BONUS'

execute dbms_mview.refresh(list=>BONUS,method=>F)

execute dbms_mview.refresh(list=>DEPT,method=>F)


scott/tiger

set serveroutput on

declare
cursor c_emp is select * from user_objects s where s.OBJECT_TYPE='MATERIALIZED VIEW';
r_emp c_emp%rowtype;
B VARCHAR2(13);
begin
open c_emp;
for i in 1..100 loop
fetch c_emp into r_emp;
exit when c_emp%notfound;
dbms_output.put_line('execute dbms_mview.refresh('||'list=>'||r_emp.object_name||','||'method=>'||'F'||')');
end loop;
close c_emp;
end;
/