‘Who am I’ in Oracle

• by krishna
• October 19, 2010

Reports information about your current database context

select ‘User: ‘|| user || ‘ on database ‘ || global_name,
       ‘  (term=’||USERENV(‘TERMINAL’)||
       ‘, audsid=’||USERENV(‘SESSIONID’)||’)’ as MYCONTEXT
from   global_name;

Reports information about your current database context select ‘User: ‘|| user || ‘ on database ‘ || global_name,        ‘  (term=’||USERENV(‘TERMINAL’)||        ‘, audsid=’||USERENV(‘SESSIONID’)||’)’ as MYCONTEXT from   global_name;