Various session parameters of SYS_CONTEXT in Oracle
select sys_context('USERENV','IP_ADDRESS') FROM DUAL
select sys_context('USERENV','ACTION') FROM DUAL
select sys_context('USERENV','AUDITED_CURSORID') FROM DUAL
select sys_context('USERENV','AUTHENTICATED_IDENTITY') FROM DUAL
select sys_context('USERENV','AUTHENTICATION_DATA') FROM DUAL
select sys_context('USERENV','AUTHENTICATION_METHOD') FROM DUAL
select sys_context('USERENV','BG_JOB_ID') FROM DUAL
select sys_context('USERENV','CLIENT_IDENTIFIER') FROM DUAL
select sys_context('USERENV','CLIENT_INFO') FROM DUAL
select sys_context('USERENV','CURRENT_BIND') FROM DUAL
select sys_context('USERENV','CURRENT_SCHEMA') FROM DUAL
select sys_context('USERENV','CURRENT_SCHEMAID') FROM DUAL
select sys_context('USERENV','CURRENT_SQL') FROM DUAL
select sys_context('USERENV','CURRENT_SQLn') FROM DUAL
select sys_context('USERENV','CURRENT_SQL_LENGTH') FROM DUAL
select sys_context('USERENV','DB_DOMAIN') FROM DUAL
select sys_context('USERENV','DB_NAME') FROM DUAL
select sys_context('USERENV','DB_UNIQUE_NAME') FROM DUAL
select sys_context('USERENV','ENTRYID') FROM DUAL
select sys_context('USERENV','ENTERPRISE_IDENTITY') FROM DUAL
select sys_context('USERENV','FG_JOB_ID') FROM DUAL --0
select sys_context('USERENV','GLOBAL_CONTEXT_MEMORY') FROM DUAL
select sys_context('USERENV','GLOBAL_UID') FROM DUAL
select sys_context('USERENV','HOST') FROM DUAL
select sys_context('USERENV','IDENTIFICATION_TYPE') FROM DUAL
select sys_context('USERENV','INSTANCE') FROM DUAL --1
select sys_context('USERENV','INSTANCE_NAME') FROM DUAL -
select sys_context('USERENV','IP_ADDRESS') FROM DUAL
select sys_context('USERENV','ISDBA') FROM DUAL
select sys_context('USERENV','LANG') FROM DUAL
select sys_context('USERENV','LANGUAGE') FROM DUAL
select sys_context('USERENV','MODULE') FROM DUAL -- TOAD 10.1.1.8
select sys_context('USERENV','NETWORK_PROTOCOL') FROM DUAL -- TCP
select sys_context('USERENV','NLS_CALENDAR') FROM DUAL --GREGORIAN
select sys_context('USERENV','NLS_CURRENCY') FROM DUAL --$
select sys_context('USERENV','NLS_DATE_FORMAT') FROM DUAL --DD-MON-RR
select sys_context('USERENV','NLS_DATE_LANGUAGE') FROM DUAL --AMERICAN
select sys_context('USERENV','NLS_SORT') FROM DUAL --BINARY
select sys_context('USERENV','NLS_TERRITORY') FROM DUAL --AMERICA
select sys_context('USERENV','OS_USER') FROM DUAL -- Lenovo
select sys_context('USERENV','POLICY_INVOKER') FROM DUAL
select sys_context('USERENV','PROXY_ENTERPRISE_IDENTITY') FROM DUAL
select sys_context('USERENV','PROXY_GLOBAL_UID') FROM DUAL
select sys_context('USERENV','PROXY_USER') FROM DUAL
select sys_context('USERENV','PROXY_USERID') FROM DUAL
select sys_context('USERENV','SERVER_HOST') FROM DUAL --abcd
select sys_context('USERENV','SERVICE_NAME') FROM DUAL --fms123
select sys_context('USERENV','SESSION_USER') FROM DUAL --scott
select sys_context('USERENV','SESSION_USERID') FROM DUAL --112
select sys_context('USERENV','SESSIONID') FROM DUAL --20858450
select sys_context('USERENV','SID') FROM DUAL --197
select sys_context('USERENV','STATEMENTID') FROM DUAL
select sys_context('USERENV','TERMINAL') FROM DUAL
select sys_context('USERENV','ACTION') FROM DUAL
select sys_context('USERENV','AUDITED_CURSORID') FROM DUAL
select sys_context('USERENV','AUTHENTICATED_IDENTITY') FROM DUAL
select sys_context('USERENV','AUTHENTICATION_DATA') FROM DUAL
select sys_context('USERENV','AUTHENTICATION_METHOD') FROM DUAL
select sys_context('USERENV','BG_JOB_ID') FROM DUAL
select sys_context('USERENV','CLIENT_IDENTIFIER') FROM DUAL
select sys_context('USERENV','CLIENT_INFO') FROM DUAL
select sys_context('USERENV','CURRENT_BIND') FROM DUAL
select sys_context('USERENV','CURRENT_SCHEMA') FROM DUAL
select sys_context('USERENV','CURRENT_SCHEMAID') FROM DUAL
select sys_context('USERENV','CURRENT_SQL') FROM DUAL
select sys_context('USERENV','CURRENT_SQLn') FROM DUAL
select sys_context('USERENV','CURRENT_SQL_LENGTH') FROM DUAL
select sys_context('USERENV','DB_DOMAIN') FROM DUAL
select sys_context('USERENV','DB_NAME') FROM DUAL
select sys_context('USERENV','DB_UNIQUE_NAME') FROM DUAL
select sys_context('USERENV','ENTRYID') FROM DUAL
select sys_context('USERENV','ENTERPRISE_IDENTITY') FROM DUAL
select sys_context('USERENV','FG_JOB_ID') FROM DUAL --0
select sys_context('USERENV','GLOBAL_CONTEXT_MEMORY') FROM DUAL
select sys_context('USERENV','GLOBAL_UID') FROM DUAL
select sys_context('USERENV','HOST') FROM DUAL
select sys_context('USERENV','IDENTIFICATION_TYPE') FROM DUAL
select sys_context('USERENV','INSTANCE') FROM DUAL --1
select sys_context('USERENV','INSTANCE_NAME') FROM DUAL -
select sys_context('USERENV','IP_ADDRESS') FROM DUAL
select sys_context('USERENV','ISDBA') FROM DUAL
select sys_context('USERENV','LANG') FROM DUAL
select sys_context('USERENV','LANGUAGE') FROM DUAL
select sys_context('USERENV','MODULE') FROM DUAL -- TOAD 10.1.1.8
select sys_context('USERENV','NETWORK_PROTOCOL') FROM DUAL -- TCP
select sys_context('USERENV','NLS_CALENDAR') FROM DUAL --GREGORIAN
select sys_context('USERENV','NLS_CURRENCY') FROM DUAL --$
select sys_context('USERENV','NLS_DATE_FORMAT') FROM DUAL --DD-MON-RR
select sys_context('USERENV','NLS_DATE_LANGUAGE') FROM DUAL --AMERICAN
select sys_context('USERENV','NLS_SORT') FROM DUAL --BINARY
select sys_context('USERENV','NLS_TERRITORY') FROM DUAL --AMERICA
select sys_context('USERENV','OS_USER') FROM DUAL -- Lenovo
select sys_context('USERENV','POLICY_INVOKER') FROM DUAL
select sys_context('USERENV','PROXY_ENTERPRISE_IDENTITY') FROM DUAL
select sys_context('USERENV','PROXY_GLOBAL_UID') FROM DUAL
select sys_context('USERENV','PROXY_USER') FROM DUAL
select sys_context('USERENV','PROXY_USERID') FROM DUAL
select sys_context('USERENV','SERVER_HOST') FROM DUAL --abcd
select sys_context('USERENV','SERVICE_NAME') FROM DUAL --fms123
select sys_context('USERENV','SESSION_USER') FROM DUAL --scott
select sys_context('USERENV','SESSION_USERID') FROM DUAL --112
select sys_context('USERENV','SESSIONID') FROM DUAL --20858450
select sys_context('USERENV','SID') FROM DUAL --197
select sys_context('USERENV','STATEMENTID') FROM DUAL
select sys_context('USERENV','TERMINAL') FROM DUAL
Tags:
Oracle