1051
xxxxxxxxxx
(PL)SQL - Sys_context
-979
Sys_context
Report
select res.*
from (select *
from (select sys_context('userenv', 'ACTION') as action
,sys_context('userenv', 'AUDITED_CURSORID') as audited_cursorid
,sys_context('userenv', 'AUTHENTICATED_IDENTITY') as authenticated_identity
,sys_context('userenv', 'AUTHENTICATION_DATA') as authentication_data
,sys_context('userenv', 'AUTHENTICATION_METHOD') as authentication_method
,sys_context('userenv', 'BG_JOB_ID') as bg_job_id
,sys_context('userenv', 'CDB_DOMAIN') as cdb_domain
,sys_context('userenv', 'CDB_NAME') as cdb_name
,sys_context('userenv', 'CLIENT_IDENTIFIER') as client_identifier
,sys_context('userenv', 'CLIENT_INFO') as client_info
,sys_context('userenv', 'CLIENT_PROGRAM_NAME') as client_program_name
,sys_context('userenv', 'CLOUD_SERVICE') as cloud_service
,sys_context('userenv', 'CON_ID') as con_id
,sys_context('userenv', 'CON_NAME') as con_name
,sys_context('userenv', 'CURRENT_BIND') as current_bind
,sys_context('userenv', 'CURRENT_EDITION_ID') as current_edition_id
,sys_context('userenv', 'CURRENT_EDITION_NAME') as current_edition_name
,sys_context('userenv', 'CURRENT_SCHEMA') as current_schema
,sys_context('userenv', 'CURRENT_SCHEMAID') as current_schemaid
,sys_context('userenv', 'CURRENT_SQL') as current_sql
,sys_context('userenv', 'CURRENT_SQL_LENGTH') as current_sql_length
,sys_context('userenv', 'CURRENT_SQLn') as current_sqln
,sys_context('userenv', 'CURRENT_USER') as current_user
,sys_context('userenv', 'CURRENT_USERID') as current_userid
,sys_context('userenv', 'DATABASE_ROLE') as database_role
,sys_context('userenv', 'DBLINK_INFO') as dblink_info
,sys_context('userenv', 'DB_DOMAIN') as db_domain
,sys_context('userenv', 'DB_NAME') as db_name
,sys_context('userenv', 'DB_SUPPLEMENTAL_LOG_LEVEL') as db_supplemental_log_level
,sys_context('userenv', 'DB_UNIQUE_NAME') as db_unique_name
,sys_context('userenv', 'DRAIN_STATUS') as drain_status
,sys_context('userenv', 'ENTERPRISE_IDENTITY') as enterprise_identity
,sys_context('userenv', 'ENTRYID') as entryid
,sys_context('userenv', 'FG_JOB_ID') as fg_job_id
,sys_context('userenv', 'GLOBAL_CONTEXT_MEMORY') as global_context_memory
,sys_context('userenv', 'GLOBAL_UID') as global_uid
,sys_context('userenv', 'HOST') as host
,sys_context('userenv', 'IDENTIFICATION_TYPE') as identification_type
,sys_context('userenv', 'INSTANCE') as instance
,sys_context('userenv', 'INSTANCE_NAME') as instance_name
,sys_context('userenv', 'IP_ADDRESS') as ip_address
,sys_context('userenv', 'ISDBA') as isdba
,sys_context('userenv', 'IS_APPLY_SERVER') as is_apply_server
,sys_context('userenv', 'IS_DG_ROLLING_UPGRADE') as is_dg_rolling_upgrade
,sys_context('userenv', 'LANG') as lang
,sys_context('userenv', 'LANGUAGE') as language
,sys_context('userenv', 'LDAP_SERVER_TYPE') as ldap_server_type
,sys_context('userenv', 'MODULE') as module
,sys_context('userenv', 'NETWORK_PROTOCOL') as network_protocol
,sys_context('userenv', 'NLS_CALENDAR') as nls_calendar
,sys_context('userenv', 'NLS_CURRENCY') as nls_currency
,sys_context('userenv', 'NLS_DATE_FORMAT') as nls_date_format
,sys_context('userenv', 'NLS_DATE_LANGUAGE') as nls_date_language
,sys_context('userenv', 'NLS_SORT') as nls_sort
,sys_context('userenv', 'NLS_TERRITORY') as nls_territory
,sys_context('userenv', 'ORACLE_HOME') as oracle_home
,sys_context('userenv', 'OS_USER') as os_user
,sys_context('userenv', 'PID') as pid
,sys_context('userenv', 'PLATFORM_SLASH') as platform_slash
,sys_context('userenv', 'POLICY_INVOKER') as policy_invoker
,sys_context('userenv', 'PROXY_ENTERPRISE_IDENTITY') as proxy_enterprise_identity
,sys_context('userenv', 'PROXY_USER') as proxy_user
,sys_context('userenv', 'PROXY_USERID') as proxy_userid
,sys_context('userenv', 'SCHEDULER_JOB') as scheduler_job
,sys_context('userenv', 'SERVER_HOST') as server_host
,sys_context('userenv', 'SERVICE_NAME') as service_name
,sys_context('userenv', 'SESSIONID') as sessionid
,sys_context('userenv', 'SESSION_DEFAULT_COLLATION') as session_default_collation
,sys_context('userenv', 'SESSION_EDITION_ID') as session_edition_id
,sys_context('userenv', 'SESSION_EDITION_NAME') as session_edition_name
,sys_context('userenv', 'SESSION_USER') as session_user
,sys_context('userenv', 'SESSION_USERID') as session_userid
,sys_context('userenv', 'SID') as sid
,sys_context('userenv', 'STANDBY_MAX_DATA_DELAY') as standby_max_data_delay
,sys_context('userenv', 'STATEMENTID') as statementid
,sys_context('userenv', 'TERMINAL') as terminal
,sys_context('userenv', 'TLS_CIPHERSUITE') as tls_ciphersuite
,sys_context('userenv', 'TLS_VERSION') as tls_version
,sys_context('userenv', 'UNIFIED_AUDIT_SESSIONID') as unified_audit_sessionid
from dual
) unpivot include nulls(val for name in(action
,audited_cursorid
,authenticated_identity
,authentication_data
,authentication_method
,bg_job_id
,cdb_domain
,cdb_name
,client_identifier
,client_info
,client_program_name
,cloud_service
,con_id
,con_name
,current_bind
,current_edition_id
,current_edition_name
,current_schema
,current_schemaid
,current_sql
,current_sql_length
,current_sqln
,current_user
,current_userid
,database_role
,dblink_info
,db_domain
,db_name
,db_supplemental_log_level
,db_unique_name
,drain_status
,enterprise_identity
,entryid
,fg_job_id
,global_context_memory
,global_uid
,host
,identification_type
,instance
,instance_name
,ip_address
,isdba
,is_apply_server
,is_dg_rolling_upgrade
,lang
,language
,ldap_server_type
,module
,network_protocol
,nls_calendar
,nls_currency
,nls_date_format
,nls_date_language
,nls_sort
,nls_territory
,oracle_home
,os_user
,pid
,platform_slash
,policy_invoker
,proxy_enterprise_identity
,proxy_user
,proxy_userid
,scheduler_job
,server_host
,service_name
,sessionid
,session_default_collation
,session_edition_id
,session_edition_name
,session_user
,session_userid
,sid
,standby_max_data_delay
,statementid
,terminal
,tls_ciphersuite
,tls_version
,unified_audit_sessionid))) res