select user from dual
------------------------------
EDV                           
1 row selected
 
 
select userenv('terminal') from dual
------------------------------
HCKC1857                      
1 row selected
 
 
select sys_context('USERENV', 'OS_USER') from dual
--------------------------------------------------------------------------------
gregor.neveling                                                                 
1 row selected
 
select sys_context('USERENV', 'AUTHENTICATION_TYPE') from dual
--------------------------------------------------------------------------------
DATABASE                                                                        
1 row selected
 
select sys_context('USERENV', 'CURRENT_SCHEMA') from dual
--------------------------------------------------------------------------------
EDV                                                                             
1 row selected
 
 
select sys_context('USERENV', 'CURRENT_SCHEMAID') from dual
--------------------------------------------------------------------------------
26                                                                              
1 row selected
 

select sys_context('USERENV', 'CURRENT_USERID') from dual
--------------------------------------------------------------------------------
26                                                                              
1 row selected
 
select sys_context('USERENV', 'DB_NAME') from dual
--------------------------------------------------------------------------------
CK8T                                                                            
1 row selected
 
 
select sys_context('USERENV', 'ENTRYID') from dual
--------------------------------------------------------------------------------
0                                                                               
1 row selected
 
 
select sys_context('USERENV', 'FG_JOB_ID') from dual
SYS_CONTEXT('USERENV','FG_JOB_                                                  
--------------------------------------------------------------------------------
0                                                                               
1 row selected
 
 
select sys_context('USERENV', 'HOST') from dual
--------------------------------------------------------------------------------
KNAUBER-HQ\HCKC1857                                                             
1 row selected
 
 
select sys_context('USERENV', 'INSTANCE') from dual
--------------------------------------------------------------------------------
1                                                                               
1 row selected
 
 
select sys_context('USERENV', 'IP_ADDRESS') from dual
--------------------------------------------------------------------------------
172.26.6.130                                                                    
1 row selected
 
 
select sys_context('USERENV', 'ISDBA') from dual
--------------------------------------------------------------------------------
FALSE                                                                           
1 row selected
 
 
select sys_context('USERENV', 'LANG') from dual
--------------------------------------------------------------------------------
D                                                                               
1 row selected
 
 
select sys_context('USERENV', 'LANGUAGE') from dual
--------------------------------------------------------------------------------
GERMAN_GERMANY.WE8ISO8859P9                                                     
1 row selected
 
 
select sys_context('USERENV', 'NETWORK_PROTOCOL') from dual
--------------------------------------------------------------------------------
tcp                                                                             
1 row selected
 
 
select sys_context('USERENV', 'NLS_CALENDAR') from dual
--------------------------------------------------------------------------------
GREGORIAN                                                                       
1 row selected
 
 
select sys_context('USERENV', 'NLS_CURRENCY') from dual
--------------------------------------------------------------------------------
DM                                                                              
1 row selected
 
 
select sys_context('USERENV', 'NLS_DATE_FORMAT') from dual
--------------------------------------------------------------------------------
DD.MM.YY                                                                        
1 row selected
 
 
select sys_context('USERENV', 'NLS_DATE_LANGUAGE') from dual
--------------------------------------------------------------------------------
GERMAN                                                                          
1 row selected
 
 
select sys_context('USERENV', 'NLS_SORT') from dual
--------------------------------------------------------------------------------
GERMAN                                                                          
1 row selected
 
 
select sys_context('USERENV', 'NLS_TERRITORY') from dual
--------------------------------------------------------------------------------
GERMANY                                                                         
1 row selected
 
 
select sys_context('USERENV', 'OS_USER') from dual
--------------------------------------------------------------------------------
gregor.neveling                                                                 
1 row selected
 
 
select sys_context('USERENV', 'PROXY_USER') from dual
--------------------------------------------------------------------------------
                                                                                
1 row selected
 
 
select sys_context('USERENV', 'PROXY_USERID') from dual
--------------------------------------------------------------------------------
                                                                                
1 row selected
 
 
select sys_context('USERENV', 'SESSION_USER') from dual
--------------------------------------------------------------------------------
EDV                                                                             
1 row selected
 
 
select sys_context('USERENV', 'SESSION_USERID') from dual
--------------------------------------------------------------------------------
26                                                                              
1 row selected
 
 
select sys_context('USERENV', 'SESSIONID') from dual
--------------------------------------------------------------------------------
205982                                                                          
1 row selected
 
 
select sys_context('USERENV', 'TERMINAL') from dual
--------------------------------------------------------------------------------
HCKC1857                                                                        
1 row selected