1.USERENV()
返回当前用户环境的信息,opt可以是:
ENTRYID,SESSIONID,TERMINAL,ISDBA,LABLE,LANGUAGE,CLIENT_INFO,LANG,VSIZE
1.ISDBA
SQL>
USEREN
------
FALSE
2.SESSIONID
SQL>
USERENV('SESSIONID')
--------------------
152
4.ENTRYID
1.USERENV()
返回当前用户环境的信息,opt可以是:
ENTRYID,SESSIONID,TERMINAL,ISDBA,LABLE,LANGUAGE,CLIENT_INFO,LANG,VSIZE
1.ISDBA
SQL>
USEREN
------
FALSE
2.SESSIONID
SQL>
USERENV('SESSIONID')
--------------------
152
4.ENTRYID