利用sqlplus将sql语句查询结果直接导出到文本文件

参考直《sqlplus 设置输出内容的相关命令》http://www.cnblogs.com/mopmoq/archive/2009/06/02/1494667.html

转自：http://blog.sina.com.cn/s/blog_53efef610100kk82.html

 
D:\>sqlplus czce/czce2008@28db
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 7月 10 14:43:23 2010
Copyright (c) 1982, 2005, Oracle.  All rights reserved.


连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> @d:\1.sql
SQL> exit
从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options 断开
 
其中1.sql文件内容：
set echo off;
set feedback off;
set verify off;
set term off;
set trimspool on;
set linesize 3000;
--set pagesize 999;
set newpage none;
set heading off;
spool d:\bbb.txt;
@d:\2.sql;
spool off;
 
 
其中2.sql文件内容为查询语句：
select t.serial_no, to_char(t.trade_date,'yyyy-mm-dd'),t.bs_flag,t.o_serial_no,t.commodity_id,t.customer_id,
t.firm_id,t.price,t.qty,t.open_price,t.liq_pl,t.l_clear_price
 from trd_trades_hist t
where t.trade_date>=to_date('2009-06-02','yyyy-mm-dd') and
      t.trade_date<to_date('2009-06-04','yyyy-mm-dd') and
      t.ol_flag='L';