ITPub博客

首页 > 数据库 > Oracle > sys_context

sys_context

原创 Oracle 作者:peng163fj 时间:2015-04-13 16:01:58 0 删除 编辑

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博客 ” ,链接:https://blog.itpub.net/21302630/viewspace-1571876/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2013-11-20

  • 博文量
    155
  • 访问量
    440176