sys_context

select SYS_CONTEXT('USERENV','TERMINAL'),

SYS_CONTEXT('USERENV','LANGUAGE'),

SYS_CONTEXT('USERENV','SESSIONID'),

SYS_CONTEXT('USERENV','INSTANCE'),

SYS_CONTEXT('USERENV','ENTRYID'),

SYS_CONTEXT('USERENV','ISDBA'),

SYS_CONTEXT('USERENV','NLS_TERRITORY'),

SYS_CONTEXT('USERENV','NLS_CURRENCY'),

SYS_CONTEXT('USERENV','NLS_CALENDAR'),

SYS_CONTEXT('USERENV','NLS_DATE_FORMAT'),

SYS_CONTEXT('USERENV','NLS_DATE_LANGUAGE'),

SYS_CONTEXT('USERENV','NLS_SORT'),

SYS_CONTEXT('USERENV','CURRENT_USER'),

SYS_CONTEXT('USERENV','CURRENT_USERID'),

SYS_CONTEXT('USERENV','SESSION_USER'),

SYS_CONTEXT('USERENV','SESSION_USERID'),

SYS_CONTEXT('USERENV','PROXY_USER'),

SYS_CONTEXT('USERENV','PROXY_USERID'),

SYS_CONTEXT('USERENV','DB_DOMAIN'),

SYS_CONTEXT('USERENV','DB_NAME'),

SYS_CONTEXT('USERENV','HOST'),

SYS_CONTEXT('USERENV','OS_USER'),

SYS_CONTEXT('USERENV','EXTERNAL_NAME'),

SYS_CONTEXT('USERENV','IP_ADDRESS'),

SYS_CONTEXT('USERENV','NETWORK_PROTOCOL'),

SYS_CONTEXT('USERENV','BG_JOB_ID'),

SYS_CONTEXT('USERENV','FG_JOB_ID'),

SYS_CONTEXT('USERENV','AUTHENTICATION_TYPE'),

SYS_CONTEXT('USERENV','AUTHENTICATION_DATA') from dual

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21302630/viewspace-1571876/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21302630/viewspace-1571876/