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/