login.sql

cat >>~/.bash_profile << EOF
export SQLPATH=\$ORACLE_HOME/sqlplus/admin/
EOF

[oracle@mbsdbp admin]$ vi login.sql
define _editor=vi
set serveroutput on size 1000000
set trimspool on
set long 5000
set linesize 200
set pagesize 9999
column plan_plus_exp format a80
column global_name new_value gname
set termout off
set timing on
define gname=idle
column global_name new_value gname
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> '

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

转载于:http://blog.itpub.net/22193071/viewspace-1190828/