1.userevn() 返回当前用户环境的信息,opt可以是: entryid,sessionid,terminal,isdba,lable,language,client_info,lang,vsize 1.isdba 查看当前用户是否是dba如果是则返回true sql select userenv('isdba') from dual; useren ------ false 2.session 返回会
1.userevn()
返回当前用户环境的信息,opt可以是:
entryid,sessionid,terminal,isdba,lable,language,client_info,lang,vsize
1.isdba 查看当前用户是否是dba如果是则返回true
sql> select userenv('isdba') from dual;
useren
------
false
2.session 返回会话标志
sql> select userenv('sessionid') from dual;
userenv('sessionid')
--------------------
152
4.entryid 返回会话人口标志
sql> select userenv('entryid') from dual;
userenv('entryid')
------------------
0
5.instance 返回当前instance的标志
sql> select userenv('instance') from dual;
userenv('instance')
-------------------
1
6.language 返回当前环境变量
sql> select userenv('language') from dual;
userenv('language')
----------------------------------------------------
simplified chinese_china.zhs16gbk
7.lang 返回当前环境的语言的缩写
sql> select userenv('lang') from dual;
userenv('lang')
----------------------------------------------------
zhs
8.terminal 返回用户的终端或机器的标志
sql> select userenv('terminal') from dual;
userenv('termina
----------------
gao
9.vsize(x) 返回x的大小(字节)数
sql> select vsize(user),user from dual;
vsize(user) user
----------- ------------------------------
6 system
2.sys_context
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;