样例:
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
本文出自 “路漫漫其修远兮…” 博客,请务必保留此出处http://baser.blog.51cto.com/4153192/1369421