Oracle-工具-SPOOL导出数据文件

set feedback off    
set heading off           
set termout on  
set verify off              
set echo off        
set pagesize 1000
set linesize 100
define filepath= ‘f:\1.log‘   
prompt *** Spooling to &filepath 
set termout off          
spool &filepath                  
select ‘insert into aa(a, b, c) values(‘‘‘|| a ||‘‘‘,‘‘‘ || b || ‘‘‘,‘‘‘ || c ||‘‘‘);‘ from table_name where 1 = 1;

spool off;