Oracle登入指令碼
Oracle登入指令碼
點選(此處)摺疊或開啟
-
REM turn off the terminal output - make it so SQLPlus does not
-
REM print out anything when we log in
-
set termout off
-
-
REM default your editor here. SQLPlus has many individual settings
-
REM This is one of the most important ones
-
define _editor=vi
-
-
REM serveroutput controls whether your DBMS_OUTPUT.PUT_LINE calls
-
REM go into the bit bucket (serveroutput off) or get displayed
-
REM on screen. I always want serveroutput set on and as big
-
REM as possible - this does that. The format wrapped elements
-
REM causes SQLPlus to preserve leading whitespace - very useful
-
set serveroutput on size 1000000 format wrapped
-
-
REM Here I set some default column widths for commonly queried
-
REM columns - columns I find myself setting frequently, day after day
-
column object_name format a30
-
column segment_name format a30
-
column file_name format a40
-
column name format a30
-
column file_name format a30
-
column what format a30 word_wrapped
-
column plan_plus_exp format a100
-
-
REM by default, a spool file is a fixed width file with lots of
-
REM trailing blanks. Trimspool removes these trailing blanks
-
REM making the spool file significantly smaller
-
set trimspool on
-
-
REM LONG controls how much of a LONG or CLOB sqlplus displays
-
REM by default. It defaults to 80 characters which in general
-
REM is far too small. I use the first 5000 characters by default
-
Set long 5000
-
-
REM This sets the default width at which sqlplus wraps output.
-
REM I use a telnet client that can go upto 200 characters wide -
-
REM hence this is my preferred setting.
-
set linesize 200
-
-
REM SQLplus will print column headings every N lines of output
-
REM this defaults to 14 lines. I find that they just clutter my
-
REM screen so this setting effectively disables them for all
-
REM intents and purposes - except for the first page of course
-
set pagesize 9999
-
-
REM MY SQL_NAME , it different from tom ,it prefer to hostname/username@database
-
REM here is how I set my signature prompt in sqlplus to
-
REM username@database> I use the NEW_VALUE concept to format
-
REM a nice prompt string that defaults to IDLE (useful for those
-
REM of you that use sqlplus to startup their databases - the
-
REM prompt will default to idle> if your database isn\'t started)
-
define gname=idle
-
column global_name new_value gname
-
select sys_context(\'userenv\', \'host\')||\'/\'||lower(user) || \'@\' ||
-
substr( global_name, 1, decode( dot,
-
0, length(global_name),
-
dot-1) ) global_name
-
from (select global_name, instr(global_name,\'.\') dot
-
from global_name );
-
set sqlprompt \'&gname> \'
-
REM and lastly, we\'ll put termout back on so sqlplus prints
-
REM to the screen
- set termout on
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29500582/viewspace-1403179/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle登陸限制指令碼Oracle指令碼
- oracle登陸設定指令碼Oracle指令碼
- 理解 Linux/Unix 登入指令碼Linux指令碼
- 【shell 指令碼】兩種登入方式指令碼
- 理解 Linux/Unix 登入指令碼的技巧Linux指令碼
- vpn登陸指令碼指令碼
- Linux使用者登入記錄分析指令碼Linux指令碼
- windows自動登入linux 並執行指令碼WindowsLinux指令碼
- 【Oracle】--PL/SQL匯入Oracle sql指令碼"傻瓜教程"OracleSQL指令碼
- ORACLE密碼檔案和登入方式Oracle密碼
- Oracle登入命令Oracle
- oracle本地登入Oracle
- 命令列登入Oracle命令列Oracle
- ORACLE限制IP登入Oracle
- Oracle rman 指令碼Oracle指令碼
- Oracle expdp 指令碼Oracle指令碼
- securt crt 自動登陸指令碼指令碼
- Shell指令碼匯入外部指令碼內容指令碼
- 關於Oracle和MySQL中的無密碼登入OracleMySql密碼
- oracle 10g em 登入亂碼的解決Oracle 10g
- Oracle 登入觸發器Oracle觸發器
- impdp 匯入 指令碼指令碼
- 【效率工具】史上最好用的SSH一鍵登入指令碼,超強更新!指令碼
- ORACLE備份指令碼Oracle指令碼
- oracle建庫指令碼Oracle指令碼
- [Oracle] 指令碼建立DBOracle指令碼
- oracle 熱備指令碼 .Oracle指令碼
- oracle自帶指令碼Oracle指令碼
- oracle 備份指令碼Oracle指令碼
- oracle 監控指令碼Oracle指令碼
- [JPT_05] 效能測試-指令碼開發(登入&隨機購買業務)指令碼隨機
- shell指令碼自動記錄登入使用者ip和歷史命令指令碼
- [Linux] SSH配置了免密碼登入,登入時還要輸入密碼Linux密碼
- 修改 MySQL 登入密碼MySql密碼
- 密碼方式登入redis密碼Redis
- SSH免密碼登入密碼
- 【網頁登入】QQ 登入、微信登入、微博登入、GitHub 登入網頁Github
- 騰訊遊戲掃碼登入原始碼遊戲原始碼