sqlplus,spool命令保存查询内容到文件

C:\Users\xuzhiguo>sqlplus scott/123456@192.168.78.221/orcl
SQL*Plus: Release 11.2.0.3.0 Production on 星期四 1月 18 17:37:27 2018
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>

SQL> spool d:/oracle1732.sql

SQL> select factory_name from pdca_factory_t where factory_name='海外';


FACTORY_NAME
--------------------------------------------------------------------------
--------------------------------------------------------------------------
----------------------------------------
海外


SQL> spool off
SQL>