【轉】SET SERVEROUTPUT ON

SET SERVEROUTPUT ON
開啟伺服器的輸出顯示,即開啟oracle自帶的輸出方法dbms_output。在執行set serveroutput on以後，使用dbms_output方法可以輸出資訊，例如：dbms_output.put_line('This is');

以下為其他引數的設定:

show all show all system variable
show user show current user
show error show errors
show parameters show parameters
set heading off forbid output column title, default is on
set feedback off forbid output statistics feedback message
default for 6 or more records

set timing on default is off, show the time elapsed while perform. query, can use it evaluate sql performance.
set sqlprompt "SQL> " setup default prompt
set linesize 1000 setup width of row, default is 100，1-32767
set pagesize 0 setup page size 該引數設定每頁輸出的行數，包括TTITLE（頭標題）、BTITLE（底標題）、COLUMN（列標題）和空行。n=0表示不產生新頁
set autocommit ON setup commit automatically, default is off
set pause on set pause, default is off
set arraysize 1 default is 15
set long 1000 default is 80
set verify off 賦值前後進行比較
set colsep Set column separate symbol
set num 16 Set width of number
set trimspool on 清空多餘的空格，如：linesize過長
set termout on If set to off, it will suppress the output of sql commands (but not the sql commands itself) if they 're run in a script.
set echo off 執行命令檔案時，命令本身是否顯示在螢幕上
set wrap off 查詢結果不換行
set markup html on
col(umn) col column format a10
col column format $999,99