Oracle Spool

Spool是SQLPLUS里的命令，写了个超级简单的脚本，将执行结果写入文件。

set echo on; --可以在输出log中显示你执行的SQL
Spool C:\TEMP\Results.log;
SELECT Count(*) FROM TEST;
Spool off;

 

测试结果：

SQL> SELECT Count(*) FROM PS_PTFP_CATG_LANG;

  COUNT(*)                                                                     
----------                                                                     
         0