oracle中用spool导出数据到文本中

spool c:\wwwwww.sqlset FEEDBACK off;set heading off;set linesize 1000;set pagesize 1000;set define off;set termout off;
select 'insert into t_table(phonenumber,name,sex)values(''' ||        phonenumber || ''',''andy'',0);'from t_table2;
select 'commit;' from dual;
spool off;set FEEDBACK on;set heading on;set define on;set termout on;

就可以生成下面格式的txt

 

insert into t_table(phonenumber,name,sex)values('15000000000','andy',0);
insert into t_table(phonenumber,name,sex)values('15000000000','andy',0);
insert into t_table(phonenumber,name,sex)values('15000000000','andy',0);
insert into t_table(phonenumber,name,sex)values('15000000000','andy',0);
insert into t_table(phonenumber,name,sex)values('15000000000','andy',0);
insert into t_table(phonenumber,name,sex)values('15000000000','andy',0);
insert into t_table(phonenumber,name,sex)values('15000000000','andy',0);
insert into t_table(phonenumber,name,sex)values('15000000000','andy',0);
insert into t_table(phonenumber,name,sex)values('15000000000','andy',0);