(8.0.26)
調べた限りなし
(19c)
https://docs.oracle.com/cd/F19136_01/sqpug/DEFINE.html#GUID-D6727C11-E4D9-4AB5-A7B8-9C6527A44A50
https://docs.oracle.com/cd/F19136_01/sqlrf/SYS_CONTEXT.html#GUID-B9934A5D-D97B-4E51-B01B-80C76A5BD086
define
_CONNECT_IDENTIFIER
_DATE
_EDITOR
_O_VERSION
_O_RELEASE
_PRIVILEGE
_SQLPLUS_RELEASE
_USER
select sys_context('userenv','ACTION') from dual;
select sys_context('userenv','IS_APPLICATION_ROOT') from dual;
select sys_context('userenv','IS_APPLICATION_PDB') 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','CDB_DOMAIN') from dual;
select sys_context('userenv','CDB_NAME') from dual;
select sys_context('userenv','CLIENT_IDENTIFIER') from dual;
select sys_context('userenv','CLIENT_INFO') from dual;
select sys_context('userenv','CLIENT_PROGRAM_NAME') from dual;
select sys_context('userenv','CON_ID') from dual;
select sys_context('userenv','CON_NAME') from dual;
select sys_context('userenv','CURRENT_BIND') from dual;
select sys_context('userenv','CURRENT_EDITION_ID') from dual;
select sys_context('userenv','CURRENT_EDITION_NAME') 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_SQL_LENGTH') from dual;
select sys_context('userenv','CURRENT_USER') from dual;
select sys_context('userenv','CURRENT_USERID') from dual;
select sys_context('userenv','DATABASE_ROLE') from dual;
select sys_context('userenv','DB_DOMAIN') from dual;
select sys_context('userenv','DB_NAME') from dual;
select sys_context('userenv','DB_SUPPLEMENTAL_LOG_LEVEL') from dual;
select sys_context('userenv','DB_UNIQUE_NAME') from dual;
select sys_context('userenv','DBLINK_INFO') 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;
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;
select sys_context('userenv','INSTANCE_NAME') from dual;
select sys_context('userenv','IP_ADDRESS') from dual;
select sys_context('userenv','IS_APPLY_SERVER') from dual;
select sys_context('userenv','IS_DG_ROLLING_UPGRADE') 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','LDAP_SERVER_TYPE') from dual;
select sys_context('userenv','MODULE') from dual;
select sys_context('userenv','NETWORK_PROTOCOL') from dual;
select sys_context('userenv','NLS_CALENDAR') from dual;
select sys_context('userenv','NLS_CURRENCY') from dual;
select sys_context('userenv','NLS_DATE_FORMAT') from dual;
select sys_context('userenv','NLS_DATE_LANGUAGE') from dual;
select sys_context('userenv','NLS_SORT') from dual;
select sys_context('userenv','NLS_TERRITORY') from dual;
select sys_context('userenv','ORACLE_HOME') from dual;
select sys_context('userenv','OS_USER') from dual;
select sys_context('userenv','PLATFORM_SLASH') from dual;
select sys_context('userenv','POLICY_INVOKER') from dual;
select sys_context('userenv','PROXY_ENTERPRISE_IDENTITY') from dual;
select sys_context('userenv','PROXY_USER') from dual;
select sys_context('userenv','PROXY_USERID') from dual;
select sys_context('userenv','SCHEDULER_JOB') from dual;
select sys_context('userenv','SERVER_HOST') from dual;
select sys_context('userenv','SERVICE_NAME') from dual;
select sys_context('userenv','SESSION_DEFAULT_COLLATION') from dual;
select sys_context('userenv','SESSION_EDITION_ID') from dual;
select sys_context('userenv','SESSION_EDITION_NAME') from dual;
select sys_context('userenv','SESSION_USER') from dual;
select sys_context('userenv','SESSION_USERID') from dual;
select sys_context('userenv','SESSIONID') from dual;
select sys_context('userenv','SID') from dual;
select sys_context('userenv','STATEMENTID') from dual;
select sys_context('userenv','TERMINAL') from dual;
select sys_context('userenv','UNIFIED_AUDIT_SESSIONID') from dual;
(14)
\set
\echo :VERSION
\echo :USER
構成関数
select
@@DATEFIRST,
@@DBTS,
@@LANGID,
@@LANGUAGE,
@@LOCK_TIMEOUT,
@@MAX_CONNECTIONS,
@@MAX_PRECISION,
@@NESTLEVEL,
@@OPTIONS,
@@SERVERNAME,
@@SERVICENAME,
@@SPID,
@@TEXTSIZE,
@@VERSION
;
