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>