sqlplus小窍门:还原session设置
上一篇:sqlplus小窍门:执行操作系统命令 下一篇:sqlplus小窍门:生成html报告

sqlplus小窍门:还原session设置

sqlplus中有很多设置,可以通过set来更改,当然,更改只对当前session生效。

通过show all可以查看当前session的所有设置

NinGoo@windows>show all
appinfo is OFF and set to "SQL*Plus"
arraysize 15
autocommit OFF
autoprint OFF
autorecovery OFF
autotrace OFF
blockterminator "." (hex 2e)
btitle OFF and is the first few characters of the next SELECT statement
cmdsep OFF
colsep " "
compatibility version NATIVE
concat "." (hex 2e)
copycommit 0
COPYTYPECHECK is ON
define "&" (hex 26)
describe DEPTH 1 LINENUM OFF INDENT ON
echo OFF
editfile "afiedt.buf"
embedded OFF
escape OFF
FEEDBACK ON for 6 or more rows
flagger OFF
flush ON
heading ON
headsep "|" (hex 7c)
instance "local"
linesize 80
lno 14
loboffset 1
logsource ""
long 80
longchunksize 80
markup HTML OFF HEAD "<style type='text/css'> body {font:10pt Arial,Helvetica,sans-ser
} p {font:10pt Arial,Helvetica,sans-serif; color:black; background:White;} table,tr,td
erif; color:Black; background:#f7f7e7; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px
ica,sans-serif; color:#336699; background:#cccc99; padding:0px 0px 0px 0px;} h1 {font:
erif; color:#336699; background-color:White; border-bottom:1px solid #cccc99; margin-t
:0px 0px 0px 0px;} h2 {font:bold 10pt Arial,Helvetica,Geneva,sans-serif; color:#336699
op:4pt; margin-bottom:0pt;} a {font:9pt Arial,Helvetica,sans-serif; color:#663300; bac
argin-bottom:0pt; vertical-align:top;}</style><title>SQL*Plus Report</title>" BODY ""
n='center' summary='Script output'" SPOOL OFF ENTMAP ON PREFORMAT OFF
newpage 1
null ""
numformat ""
numwidth 10
pagesize 14
PAUSE is OFF
pno 0
recsep WRAP
recsepchar " " (hex 20)
release 1002000100
repfooter OFF and is NULL
repheader OFF and is NULL
serveroutput OFF
shiftinout INVISIBLE
showmode OFF
spool OFF
sqlblanklines OFF
sqlcase MIXED
sqlcode 0
sqlcontinue "> "
sqlnumber ON
sqlpluscompatibility 10.2.0
sqlprefix "#" (hex 23)
sqlprompt "_USER'@'_CONNECT_IDENTIFIER>"
sqlterminator ";" (hex 3b)
suffix "sql"
tab ON
termout ON
timing OFF
trimout ON
trimspool OFF
ttitle OFF and is the first few characters of the next SELECT statement
underline "-" (hex 2d)
USER is "NING"
verify ON
wrap : lines will be wrapped

也可以通过show 设置名来查看某个设置的值
NinGoo@windows>show linesize
linesize 80

可以利用set命令更改设置
NinGoo@windows>set linesize 120
NinGoo@windows>show linesize
linesize 120

可以利用store命令保存当前的所有设置到脚本中,然后通过执行该脚本还原session的所有设置
NinGoo@windows>store set sqlplusset
Created file sqlplusset
NinGoo@windows>set linesize 200
NinGoo@windows>show linesize
linesize 200
NinGoo@windows>@sqlplusset
NinGoo@windows>show linesize
linesize 120

本文网址:http://www.ningoo.net/html/2007/sqlplus_tips_restore_session_set.html

订阅到Google | 收藏到Del.icio.us | 推荐到鲜果

相关文章 随机文章

本文Tags: ,

没有评论


(Required)
(Required, will not be published)