oracle数据库userenv,Oracle 中的userenv()

select

sys_context('userenv','terminal') terminal,

sys_context('userenv','language') language,

sys_context('userenv','sessionid') sessionid,

sys_context('userenv','instance') instance,

sys_context('userenv','entryid') entryid,

sys_context('userenv','isdba') isdba,

sys_context('userenv','nls_territory') nls_territory,

sys_context('userenv','nls_currency') nls_currency,

sys_context('userenv','nls_calendar') nls_calendar,

sys_context('userenv','nls_date_format') nls_date_format,

sys_context('userenv','nls_date_language') nls_date_language,

sys_context('userenv','nls_sort') nls_sort,

sys_context('userenv','current_user') current_user,

sys_context('userenv','current_userid') current_userid,

sys_context('userenv','session_user') session_user,

sys_context('userenv','session_userid') session_userid,

sys_context('userenv','proxy_user') proxy_user,

sys_context('userenv','proxy_userid') proxy_userid,

sys_context('userenv','db_domain') db_domain,

sys_context('userenv','db_name') db_name,

sys_context('userenv','host') host,

sys_context('userenv','os_user') os_user,

sys_context('userenv','external_name') external_name,

sys_context('userenv','ip_address') ip_address,

sys_context('userenv','network_protocol') network_protocol,

sys_context('userenv','bg_job_id') bg_job_id,

sys_context('userenv','fg_job_id') fg_job_id,

sys_context('userenv','authentication_type') authentication_type,

sys_context('userenv','authentication_data') authentication_data

from dual;

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值