Oracle删除以XX开头的表的数据

Oracle删除以XX开头的表的数据

  delete from T04001QUESTION_INF;
  for t in (select table_name from user_tables where table_name like 'T03%' or table_name like 'T06%' or table_name like 'T08%' ) loop
   execute immediate 'delete from '||t.table_name;
  end loop;