【转】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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26892340/viewspace-721936/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26892340/viewspace-721936/