drop数据库中表明前两个字符为OA的所有表

先构造drop的sql语句
select 'drop table '||table_name ||';'from all_tables
where table_name like 'OA%'
然后得到
'DROPTABLE'||TABLE_NAME||';'
------------------------------------------
drop table OA_ATTACHMENT;
drop table OA_CAIGOU;
drop table OA_CHANNEL;
drop table OA_CHANNEL_ROLE;
drop table OA_COMMON_FORM;
drop table OA_COMMON_OPINION;
drop table OA_CUIBAN;
drop table OA_DUBAN;
drop table OA_DUBAN_CUIBANJILU;
drop table OA_DUBAN_HUIZONG;
drop table OA_DUBAN_LINGDAOPISHI;

'DROPTABLE'||TABLE_NAME||';'
------------------------------------------
drop table OA_FAWEN_SEND_WORD;
drop table OA_HTMLCONTENT;
drop table OA_HTMLTEMPLATE;
drop table OA_HUIYIJILU;
drop table OA_KAOQIN;
drop table OA_LEADERAGENDA;
drop table OA_LINGDAOJIANGGAO;
drop table OA_LINSHIZHUSU_FLAG;
drop table OA_MEETING;
drop table OA_MEETING_APPLY;
drop table OA_MEETING_HUIYIDENGJI;

'DROPTABLE'||TABLE_NAME||';'
------------------------------------------
drop table OA_MEETING_HUIYIFANGAN;
drop table OA_PICTURE;
drop table OA_PICTYPE;
drop table OA_QIANBAO;
drop table OA_SHEBEI;
drop table OA_SHOUWEN;
drop table OA_SIGN;
drop table OA_WEEKPLAN;
drop table OA_WENJIANTYPE;
drop table OA_WORDCHANGE_ITEMLOG;
drop table OA_WORDCHANGE_LOG;

'DROPTABLE'||TABLE_NAME||';'
------------------------------------------
drop table OA_WORDCHANGE_NOTE;
drop table OA_WORDCHANGE_TYPE;
drop table OA_XINFANG;
drop table OA_ZHENGWEN;
然后再执行这些sql语句，够笨的，可以写存储过程。