样例：

SET BTITLE OFF
SET COLSEP ""
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING OFF
SET LINESIZE 9999
SET NEWPAGE NONE
SET PAGESIZE 0
SET PAUSE OFF
SET SERVEROUTPUT ON
SET SPACE 0
SET TERM OFF
SET TIMING OFF
SET TRIMOUT ON
SET TRIMSPOOL ON
SET TTITLE OFF
SET VERIFY OFF
SET WRAP ON

SPOOL E:\1.TXT
SELECT SEGMENT1 || ',' || attribute10 FROM MTL_SYSTEM_ITEMS_B WHERE ROWNUM<=5;
SPOOL OFF

 

各设置含义请参考我另一篇博文：SQL*PLUS Options