日期:2014-05-17  浏览次数:21341 次

SET SERVEROUTPUT ON 是什么意思
SET   SERVEROUTPUT   ON   是什么意思
有没有其他的所有的命令的解释?

------解决方案--------------------
SET SERVEROUTPUT ON
打开服务器的输出显示
------解决方案--------------------
使用set serveroutput on 命令设置环境变量serveroutput为打开状态,从而使得pl/sql程序能够再SQL*plus和SQL*plus中输出结果

使用函数dbms_output.put_line()可以输出参数的值。


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