1 概述
目的:获取 Oracle 环境上下文数据,如:当前用户、IP、host 等
2 语法
select sys_context('USERENV', '参数值') from dual;
常用:
select sys_context('USERENV', 'CURRENT_USER') current_user,
sys_context('USERENV', 'SESSIONID') sessionid,
sys_context('USERENV', 'SESSION_USER') session_user,
sys_context('USERENV', 'HOST') host,
sys_context('USERENV', 'IP_ADDRESS') ip_address,
sys_context('USERENV', 'ISDBA') isdba,
sys_context('USERENV', 'LANGUAGE') language,
sys_context('USERENV', 'OS_USER') os_user,
sys_context('USERENV', 'TERMINAL') terminal
from dual;