oracle中的全局环境变量配置

oracle中增加全局环境变量配置

在oracle的.profile或者.bash_profile中增加
SQLPATH=$ORACLE_HOME
export SQLPATH

保存退出后编辑$ORACLE_HOME/login.sql
set lines 160
set pages 80
set timing on
set time off
set termout on
set trimout ON
set trimspool On
set serveroutput on size 100000 format wrapped
set long 5000
-- define gname=idle
-- column global_name new_value gname for a40
-- SELECT lower(USER) || '@' ||upper(instance_name)||'('||nvl(UTL_INADDR.GET_HOST_ADDRESS, SYS_CONTEXT('userenv', 'ip_address'))||')' GLOBAL_NAME FROM v$instance;
-- 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> '

[@more@]

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

转载于:http://blog.itpub.net/8806316/viewspace-1035199/