Thursday, 26 April 2012

Who am I, script


set termout off
store set store rep
set head off
set pause off
set termout on
 
select 'User: '|| user || ' on database ' || global_name,
       '  (term='||USERENV('TERMINAL')||
       ', audsid='||USERENV('SESSIONID')||')' as MYCONTEXT
from   global_name;
 
@store
set termout on

No comments:

Post a Comment