17,081
社区成员
发帖
与我相关
我的任务
分享
declare
v_sql varchar2(2000) ;
CURSOR cur is select table_name from user_tables order by table_name;
begin
for rows in cur loop v_sql := 'drop TABLE ' || rows.table_name||' cascade constraints';
dbms_output.put_line(v_sql);
execute immediate v_sql;
end loop;
end;