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@]