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;
阅读(1144) | 评论(0) | 转发(0) |
