7.显示和设置环境变量

 使用sql*plus的环境变量可以控制其运行环境，例如设置行显示宽度，设置每页显示的行数、

设置自动提交标记、设置自动跟踪等等。使用show命令可以显示当前sql*plus的环境变量设置

:使用set命令可以修改当前sql*plus的环境变量设置。下面介绍常用的sql*plus环境变量。

(1)显示所有环境变量

 为了显示sql*plus的所有环境变量，必须要使用show all命令。示例如下:

SQL> show all

appinfo 为 OFF 并且已设置为 "SQL*Plus"

arraysize 15

autocommit OFF

autoprint OFF

autorecovery OFF

autotrace OFF

blockterminator "." (hex 2e)

btitle OFF 为下一条 SELECT 语句的前几个字符

cmdsep OFF

colsep " "

compatibility version NATIVE

concat "." (hex 2e)

copycommit 0

COPYTYPECHECK 为 ON

define "&" (hex 26)

describe DEPTH 1 LINENUM OFF INDENT ON

echo OFF

editfile "afiedt.buf"

embedded OFF

escape OFF

用于 6 或更多行的 FEEDBACK ON

flagger OFF

flush ON

heading ON

headsep "|" (hex 7c)

instance "local"

linesize 80

lno 4

loboffset 1

logsource ""

long 80

longchunksize 80

markup HTML OFF HEAD " body {font:10pt Arial,Helvetica,sans-serif; color:black; background:White;} p {font:10pt Arial,Helvetica,sans-serif; color:black; background:White;} table,tr,td {font:10pt Arial,Helvetica,sans-serif; color:Black; background:#f7f7e7; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px;} th {font:bold 10pt Arial,Helvetica,sans-serif; color:#336699; background:#cccc99; padding:0px 0px 0px 0px;} h1 {font:16pt Arial,Helvetica,Geneva,sans-serif; color:#336699; background-color:White; border-bottom:1px solid #cccc99; margin-top:0pt; margin-bottom:0pt; padding:0px 0px 0px 0px;} h2 {font:bold 10pt Arial,Helvetica,Geneva,sans-serif; color:#336699; background-color:White; margin-top:4pt; margin-bottom:0pt;} a {font:9pt Arial,Helvetica,sans-serif; color:#663300; background:#ffffff; margin-top:0pt; margin-bottom:0pt; vertical-align:top;}" BODY "" TABLE "border='1' width='90%' align='center' summary='Script. output'" SPOOL OFF ENTMAP ON PREFORMAT OFF

newpage 1

null ""

numformat ""

numwidth 10

pagesize 14

PAUSE 为 OFF

pno 1

recsep WRAP

recsepchar " " (hex 20)

release 1002000100

repfooter OFF  为 NULL

repheader OFF  为 NULL

serveroutput OFF

shiftinout INVISIBLE

showmode OFF

spool ON

sqlblanklines OFF

sqlcase MIXED

sqlcode 0

sqlcontinue "> "

sqlnumber ON

sqlpluscompatibility 10.2.0

sqlprefix "#" (hex 23)

sqlprompt "SQL> "

sqlterminator ";" (hex 3b)

suffix "sql"

tab ON

termout ON

timing OFF

trimout ON

trimspool OFF

ttitle OFF 为下一条 SELECT 语句的前几个字符

underline "-" (hex 2d)

USER 为 "SCOTT"

verify ON

wrap : 将换至下一行

SQL> spool off