修改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常见的使用习惯设置。
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博客 ” ，链接：https://blog.itpub.net/29497382/viewspace-1171624/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
oracle常用文档
下一篇：
sqlplus的常见设置
请登录后发表评论
登录
全部评论
