oracle spool

样例：

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

oracle spool,布布扣,bubuko.com

oracle spool

原文：http://baser.blog.51cto.com/4153192/1369421