Oracle login.sql

--set SQLPATH=D:/oracle/product/10.2.0/db_1/bin

 

-- define _editor=vi

 

set serveroutput on

 

set linesize 100

 

set pagesize 9999

 

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