--定义一个变量
define gname=idle
--把global_name列中的最后一个值赋值给GNAME
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> '