SYS_CONTEXT

select SYS_CONTEXT('USERENV','TERMINAL'),

SYS_CONTEXT('USERENV','LANGUAGE'),

SYS_CONTEXT('USERENV','SESSIONID'),

SYS_CONTEXT('USERENV','INSTANCE'),

SYS_CONTEXT('USERENV','ENTRYID'),

SYS_CONTEXT('USERENV','ISDBA'),

SYS_CONTEXT('USERENV','NLS_TERRITORY'),

SYS_CONTEXT('USERENV','NLS_CURRENCY'),

SYS_CONTEXT('USERENV','NLS_CALENDAR'),

SYS_CONTEXT('USERENV','NLS_DATE_FORMAT'),

SYS_CONTEXT('USERENV','NLS_DATE_LANGUAGE'),

SYS_CONTEXT('USERENV','NLS_SORT'),

SYS_CONTEXT('USERENV','CURRENT_USER'),

SYS_CONTEXT('USERENV','CURRENT_USERID'),

SYS_CONTEXT('USERENV','SESSION_USER'),

SYS_CONTEXT('USERENV','SESSION_USERID'),

SYS_CONTEXT('USERENV','PROXY_USER'),

SYS_CONTEXT('USERENV','PROXY_USERID'),

SYS_CONTEXT('USERENV','DB_DOMAIN'),

SYS_CONTEXT('USERENV','DB_NAME'),

SYS_CONTEXT('USERENV','HOST'),

SYS_CONTEXT('USERENV','OS_USER'),

SYS_CONTEXT('USERENV','EXTERNAL_NAME'),

SYS_CONTEXT('USERENV','IP_ADDRESS'),

SYS_CONTEXT('USERENV','NETWORK_PROTOCOL'),

SYS_CONTEXT('USERENV','BG_JOB_ID'),

SYS_CONTEXT('USERENV','FG_JOB_ID'),

SYS_CONTEXT('USERENV','AUTHENTICATION_TYPE'),

SYS_CONTEXT('USERENV','AUTHENTICATION_DATA') from dual