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

spool c:\wwwwww.sql
set 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);