在linux下的目录/u01/oracle/sqlplus/admin下编写了一个login.sql,代码如下
---login.sql--
define _editor=vim
set serveroutput on size 1000000
set trimspool on
set long 5000
set linesize 100
set pagesize 9999
column plan_plus_exp format a80
column global_name new_value gname
set termout off
define gname=idle
column global_name new_value gname
select lower(user) || '@' || substr( global_name, 1, decode( dot, 0, length(glob
al_name),
dot-1) ) global_name
from (select global_name, instr(global_name,'.') dot from global_name );
set sqlprompt '&gname> '
set termout on
然后配置SQLPATH,打开/u01/oracle/.bash_profile,在里面添加
export SQLPATH=/u01/oracle/sqlplus/admin
也可配为
export SQLPATH=$ORACLE_HOME/sqlplus/admin
下次再启动时,就会自动调用login.sql