declare
vsql varchar2(200);
cursor c1 is
select 'drop table '||table_name||' cascade constraints' v_name
from user_tables;
BEGIN
for i in c1 loop
vsql:=i.v_name;
execute immediate vsql;
end loop;
end;
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/222196.html原文链接:https://javaforall.net
