批量删除表的一个例子

declare
  cursor c1 is
    select table_name from user_tables where table_name  like '%EQ_DEFECTMANAGE%';
begin
  for c2 in c1 loop
    execute immediate 'drop table ' || c2.table_name;
  end loop;
end;