在进入oracle里有些格式需要手工修改，下次重新登录的时候就需重新设置，如何避免这种情况呢?
参考如下脚本，根据实际情况编写，把语句放到$ORACLE_HOME/sqlplus/admin/glogin.sql中，
每次进入oracle就会自动调用了：）
|
define _editor=vi
set serveroutput on size 1000000
set trimspool on
set long 5000
set linesize 100
set pagesize 9999
set termout off
col NAME_COL_PLUS_SHOW_PARAM for a36
col TYPE for a20
col VALUE_COL_PLUS_SHOW_PARAM for a20
col plan_plus_exp format a80
col global_name new_value gname
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> '
set termout on
|
阅读(925) | 评论(1) | 转发(0) |
