oracle实现批量drop表,ORACLE下批量DROP表格

select 'drop table '||table_name||';' from user_tables where table_name like 'R_%'; 选出所有符合要求的用户表  ,将结果执行即可 drop table R_DATABASE_ATTRIBUTE; drop table R_DEPENDENCY; drop table R_JOBENTRY; drop table R_JOBENTRY_ATTRIBUTE; drop table R_JOBENTRY_COPY; drop table R_JOBENTRY_TYPE; drop table R_JOB_ATTRIBUTE; drop table R_JOB_HOP; drop table R_JOB_NOTE; drop table R_LOG; drop table R_LOGLEVEL; drop table R_NOTE; drop table R_PARTITION; drop table R_PARTITION_SCHEMA; drop table R_PERMISSION; drop table R_PROFILE; drop table R_PROFILE_PERMISSION; drop table R_REPOSITORY_LOG; drop table R_SLAVE; drop table R_STEP; drop table R_STEP_ATTRIBUTE; drop table R_STEP_DATABASE; drop table R_STEP_TYPE; drop table R_TRANSFORMATION; drop table R_TRANS_ATTRIBUTE; drop table R_TRANS_CLUSTER; drop table R_TRANS_HOP; drop table R_TRANS_NOTE; drop table R_TRANS_PARTITION_SCHEMA; drop table R_TRANS_SLAVE; drop table R_TRANS_STEP_CONDITION; drop table R_USER; drop table R_VALUE; drop table R_VERSION;