Oracle入门(五C)之68个系统变量的key和默认value
生活随笔
收集整理的這篇文章主要介紹了
Oracle入门(五C)之68个系统变量的key和默认value
小編覺得挺不錯的,現在分享給大家,幫大家做個參考.
Oracle的68個系統變量的key和默認value
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 escchar OFF exitcommit ON 用于 6 或更多行的 FEEDBACK ON 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-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; backg round:#f7f7e7; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px;} th {font:bold 10pt Aria l,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; bor der-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;}</s tyle><title>SQL*Plus Report</title>" 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 0 recsep WRAP recsepchar " " (hex 20) release 1102000100 repfooter OFF 為 NULL repheader OFF 為 NULL securedcol is OFF serveroutput OFF shiftinout INVISIBLE showmode OFF spool OFF sqlblanklines OFF sqlcase MIXED sqlcode 0 sqlcontinue "> " sqlnumber ON sqlpluscompatibility 11.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 為 "SYS" verify ON wrap : 將換至下一行 errorlogging is OFF
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 escchar OFF exitcommit ON 用于 6 或更多行的 FEEDBACK ON 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-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; backg round:#f7f7e7; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px;} th {font:bold 10pt Aria l,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; bor der-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;}</s tyle><title>SQL*Plus Report</title>" 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 0 recsep WRAP recsepchar " " (hex 20) release 1102000100 repfooter OFF 為 NULL repheader OFF 為 NULL securedcol is OFF serveroutput OFF shiftinout INVISIBLE showmode OFF spool OFF sqlblanklines OFF sqlcase MIXED sqlcode 0 sqlcontinue "> " sqlnumber ON sqlpluscompatibility 11.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 為 "SYS" verify ON wrap : 將換至下一行 errorlogging is OFF
總結
以上是生活随笔為你收集整理的Oracle入门(五C)之68个系统变量的key和默认value的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: 网吧电脑什么配置?
- 下一篇: Oracle入门(三B)之11G新特性