declare
cursor tname is select * from all_tables t where t.OWNER='C##BENZ' ;
t_name varchar2(32);
begin
t_name:='select * from ';
for ta in tname loop
execute immediate t_name||ta.table_name;
dbms_output.put_line(ta.table_name);
end loop;
end;
/
oracle 操作工具,删除用户下所有的表
最新推荐文章于 2024-06-13 15:30:37 发布