set verify off linesize 100 pagesize 5000 long 4096 arraysize 2
define gname = 'not connected'
column global_name new_value gname
set termout off
select lower(user) || '@' || replace(global_name,'.ORACLE',null) global_name
from global_name;
set termout on
set sqlprompt '&&gname> '
define gname = 'not connected'
column global_name new_value gname
set termout off
select lower(user) || '@' || replace(global_name,'.ORACLE',null) global_name
from global_name;
set termout on
set sqlprompt '&&gname> '
set echo on;
spool filename.log
spool filename.log