login.sql
tom kyte login.sql[@more@]define _editor=vi
set serveroutput on size 1000000
set trimspool on
set long 5000
set linesize 100
set pagesize 9999
col plan_plus_exp for a80
col gloabl_name new_value gname
set termout off
define gname=idle
col 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
col plan_plus_exp for a80
col gloabl_name new_value gname
set termout off
define gname=idle
col 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/309902/viewspace-1057487/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle login.sqlOracleSQL
- 定製login.sqlSQL
- oracle glogin.sql 和login.sqlOracleSQL
- oracle中SQLPLUS的Login.sqlOracleSQL
- sqlplus環境配置(login.sql)SQL
- Oracle glogin.sql 和login.sql使用OracleSQL
- SQL *Plus設定login.sql登入設定SQL
- [20140221]login.sql與系統安全.txtSQL
- Oracle通過login.sql實現永久修改sqlplus引數OracleSQL
- oracle login.sql登入時的環境初始化(unix/linux環境)OracleSQLLinux
- [20230124]12c訪問login.sql指令碼.txtSQL指令碼
- login.sql所在的位置 顯示當前連線的oracle SID及使用者命令 轉載SQLOracle