在SQL/plus下 ，查询语句直接保存成TXT文档

OraToTxt.sql   内容如下：

spool c:/a.txt
set termout off
set echo off
set feedback off
set heading off
set line 1000
select * from basshp;
spool off

 

 

 

连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> @E:/tools/OraToTxt.sql
SQL> select * from basshp;

         1 0108                 总部
SQL>