DanBrother的部落格

SQL to Drop Oracle SQL Analyze Standalone Repository Objects?

begin 
  for rec in (select object_name,object_type
              from user_objects where object_name like 'EPC_%'
              or object_name like 'SMP_%' or object_name like 'VBZ$%'
              or object_name like 'VDK_%' or object_name like 'VMQ_%'
              order by object_type
              ) loop
      if rec.object_type = 'TABLE' then
         execute immediate 'drop table '||rec.object_name||' cascade constraints';
      elsif rec.object_type = 'SEQUENCE' then
         execute immediate 'drop sequence '||rec.object_name;
      elsif rec.object_type = 'TYPE' then
         execute immediate 'drop type '||rec.object_name||' force';
      elsif rec.object_type = 'VIEW' then
         execute immediate 'drop view '||rec.object_name;
      end if;
  end loop;
end;
/