declare v_sql varchar2(200); begin for xx in (select * from user_objects t order by t.OBJECT_TYPE desc) loop begin v_sql := 'drop ' || xx.object_type || ' ' || xx.object_name; execute immediate v_sql; exception when others then dbms_output.put_line(v_sql); end; end loop; end;
v_sql varchar2(200);
begin
for xx in (select * from user_objects t order by t.OBJECT_TYPE desc) loop
begin
v_sql := 'drop ' || xx.object_type || ' ' || xx.object_name;
execute immediate v_sql;
exception
when others then
dbms_output.put_line(v_sql);
end;
end loop;
end;