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
--这句话的意思是SQL查询出来的global_name列的值存入gname变量
select upper(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
















