login.sql

define gname = 'not connected'
column global_name new_value gname
set pages 999 
set termout off
select lower(user) || '@' || lower(substr(global_name, 1,  instr(global_name, '.', 1) - 1)) global_name
from global_name;
set termout on
set sqlprompt '&&gname> '