修改sqlplus默认环境设置

1:sqlplus 的默认环境设置
There are two startup files for SQL*Plus:
GLOGIN.SQL, which is the global startup file
LOGIN.SQL,  which is designed for local and individual use
Whenever any user starts SQL*Plus, first the GLOGIN.SQL file is read, followed by the user's LOGIN.SQL file.


2:测试
$ORACLE_HOME/sqlplus/admin/glogin.sql
define base=/u01/
define gvar=glogin


~/login.sql
define data=&base/oradata
define gvar=login


SQL> select '&base' from dual;
old   1: select '&base' from dual
new   1: select '/u01/' from dual


'/U01
-----
/u01/


SQL> select '&data' from dual;
old   1: select '&data' from dual
new   1: select '/u01//oradata' from dual


'/U01//ORADAT
-------------
/u01//oradata


SQL> select '&gvar' from dual;
old   1: select '&gvar' from dual
new   1: select 'login' from dual


'LOGI
-----
login

3：总结：
(2)中的测试验证了(1)中的描述。

实际应用
(1)修改sqlplus的提示符和sqlplus命令编辑工具
$ORACLE_HOME/sqlplus/admin/glogin.sql
set sqlprompt "_user'@'_connect_identifier> "
define_editor='vi'

还可以在glogin.sql 和 loging.sql常见的使用习惯设置。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29497382/viewspace-1171624/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29497382/viewspace-1171624/