declare
cursor drop_cur is
select table_name from user_tables;
v_tname user_tables.table_name%type;
begin
open drop_cur;
fetch drop_cur into v_tname;
while drop_cur%found loop
execute immediate 'drop table ' || v_tname || ' cascade constraint';
fetch drop_cur into v_tname;
end loop;
close drop_cur;
end;
/
cursor drop_cur is
select table_name from user_tables;
v_tname user_tables.table_name%type;
begin
open drop_cur;
fetch drop_cur into v_tname;
while drop_cur%found loop
execute immediate 'drop table ' || v_tname || ' cascade constraint';
fetch drop_cur into v_tname;
end loop;
close drop_cur;
end;
/
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货