declare
cursor c1 is select table_name from dba_tables where owner='REPORT';
begin
for c2 in c1 loop
execute immediate 'drop table REPORT.'||c2.table_name;
end loop;
end;
这个语句是oracle中删除report用户全部表的sql程序
我在pl developer中可以执行,但把这个做成sql文件后用bat命令执行就执行不了(程序不动)
请问怎么办啊?