使用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 up html on col(umn) col column format a10 col column format $999,99
打开服务器的输出显示
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 up html on
col(umn) col column format a10
col column format $999,99