Declare
Cursor mycur Is Select table_name From dba_All_Tables Where owner='dbUser';
vtable Varchar(50);
vsql Varchar(500);
Begin
for emp_record in mycur Loop
vtable := emp_record.table_name;
vsql := 'Select * From '||vtable;
--Execute IMMEDIATE vsql;
dbms_output.put_line(vsql);
End Loop;
End;
Cursor mycur Is Select table_name From dba_All_Tables Where owner='dbUser';
vtable Varchar(50);
vsql Varchar(500);
Begin
for emp_record in mycur Loop
vtable := emp_record.table_name;
vsql := 'Select * From '||vtable;
--Execute IMMEDIATE vsql;
dbms_output.put_line(vsql);
End Loop;
End;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7607759/viewspace-22204/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7607759/viewspace-22204/