Oracle SYS_CONTEXT(namespace, parameter)
-- Some SYS_CONTEXT values
SELECT
  SYS_CONTEXT('USERENV','DB_NAME')              db_name,
  SYS_CONTEXT('USERENV','DB_UNIQUE_NAME')       db_unique_name, 
  SYS_CONTEXT('USERENV','INSTANCE')             instance,
  SYS_CONTEXT('USERENV','INSTANCE_NAME')        instance_name,
  SYS_CONTEXT('USERENV','DATABASE_ROLE')        db_role,
  SYS_CONTEXT('USERENV','SERVICE_NAME')         service_name,
  SYS_CONTEXT('USERENV','LANGUAGE')             language,
  SYS_CONTEXT('USERENV','HOST')                 CLIENT_host,
  SYS_CONTEXT('USERENV','SESSION_USER')         session_user,
  SYS_CONTEXT('USERENV','OS_USER')              os_user,
  SYS_CONTEXT('USERENV','SERVER_HOST')          server_host,
  SYS_CONTEXT('USERENV','NETWORK_PROTOCOL')     network_protocol,  
  SYS_CONTEXT('USERENV','IP_ADDRESS')           ip_address,
  SYS_CONTEXT('USERENV','NLS_DATE_FORMAT')      nls_date_format,
  SYS_CONTEXT('USERENV','NLS_CURRENCY')         nls_currency,
  SYS_CONTEXT('USERENV','NLS_SORT')             nls_sort,
  SYS_CONTEXT('USERENV','NLS_TERRITORY')        nls_territory,
  SYS_CONTEXT('USERENV','MODULE')               application,
  SYS_CONTEXT('USERENV','TERMINAL')             terminal,
  SYS_CONTEXT('USERENV','CURRENT_SCHEMA')       current_schema,
  SYS_CONTEXT('USERENV','CURRENT_SCHEMAID')     current_schemaid,
  SYS_CONTEXT('USERENV','SESSIONID')            sessionid,
  SYS_CONTEXT('USERENV','SID')                  sid,
  SYS_CONTEXT('USERENV','ENTERPRISE_IDENTITY')  enterprise_id,
  SYS_CONTEXT('USERENV','POLICY_INVOKER')       policy_invoker,
  SYS_CONTEXT('USERENV','CURRENT_SQL')          current_sql
FROM DUAL;
Sys_Context Values as a - PL/SQL Block

Oracle registered trademark of Oracle Corporation.

Last Revised on: March 05th, 2012

  55018