Customized SQL Prompt

open $ORACLE_HOME/sqlplus/admin/glogin.sql

column global_name new_value gname
set termout off
select lower(user) || '@' || substr(global_name,1,instr(global_name,'.',1)-1) global_name
from global_name;
set termout on
set sqlprompt '&gname SQL> '