plsql登录glogin.sql

vi /u01/app/oracle/product/10.2.0/db_1/sqlplus/admin/glogin.sql

DEFINE _EDITOR  = "vi"
set linesize 120
set pagesize 200
set sqlprompt "_user>"
set serveroutput on size 1000000
set trimspool on long 5000
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(global_name),dot-1))global_name from(s
electglobal_name,instr(global_name,'.')dotfromglobal_name);
setsqlprompt'&gname>'
settermouton