-- --------------------------------
-- SQL*Plus login script
-- A Noble 2006
-- based on Tom Kyte's login script
-- --------------------------------
-- set up editor to be UltraEdit by default
define _editor="C:\Program Files\IDM COMPUTER SOLUTIONS\ULTRAEDIT-32\uedit32.exe"
set serveroutput on size 1000000 format wrapped
set trimspool on
set long 500
set linesize 100
set pagesize 9999
column global_name new_value gname
set termout off
define gname=idle
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> '
set termout on