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

上一篇:CentOS下yum安装mysql,jdk以及tomcat


下一篇:oracle安装常见问题-