glogin.sql
設定檔案glogin.sql 執行sqlplus後都會呼叫該指令碼。
define _editor=vi
set serveroutput on size 1000000
set trimspool on
set long 5000
set linesize 100
set pagesize 9999
column plan_plus_exp format a80
column global_name new_value gname
set termout off
define gname=idle
column global_name new_value gname
select 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> '
set termout on
set serveroutput on size 1000000
set trimspool on
set long 5000
set linesize 100
set pagesize 9999
column plan_plus_exp format a80
column global_name new_value gname
set termout off
define gname=idle
column global_name new_value gname
select 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> '
set termout on
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/25323853/viewspace-708821/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- glogin.sql?指令碼SQL指令碼
- Oracle 10g glogin.sqlOracle 10gSQL
- oracle glogin.sql 和login.sqlOracleSQL
- sqlplus中glogin.sql的例子SQL
- Oracle glogin.sql 和login.sql使用OracleSQL
- sqlplus登陸環境設定(glogin.sql)SQL
- glogin.sql配置不當引起sqlplus hang的假象分析SQL
- 如何用glogin.sql控制sqlplus工具的環境配置SQL
- 更改glogin.sql檔案,自定義SQLPLUS使用環境SQL
- 永久設定sql*plus的環境變數(glogin.sql的設定)SQL變數
- 修改glogin.sql引發的生產系統監控的虛假報警SQL
- 【SQLPLUS】sqlplus使用小Tips之glogin.sql統一環境配置檔案SQL