오라클 특정(일부) 테이블 Drop

Begin

   for c in (select table_name from user_tables where table_name like 'COMTN%') loop

  execute immediate ('drop table '||c.table_name||' cascade constraints');

  end loop;

  End;