===========================================================
获取当前用户SID的几种方法.
===========================================================
Author: lijietz(http://lijietz.itpub.net)
Date:2005.08.17 12:09
Catagories: oracle 技术
Source：http://lijietz.itpub.net/post/4988/38360
---------------------------------------------------------------
Date:2005.08.17 12:09
Catagories: oracle 技术
Source：http://lijietz.itpub.net/post/4988/38360
---------------------------------------------------------------
1:
SELECT
TO_NUMBER(SUBSTRdbms_session.unique_session_id,1,4),'XXXX') FROM DUAL ;
备注:
以下方法获取的不是当前用户的sid.
select SYS_CONTEXT('USERENV','SESSIONID') sessionid
from dual
而是audit session id。
SYS_CONTEXT('USERENV','SESSIONID') = v$session.AUDSID
参见:
http://www.itpub.net/showthread.php?=&postid=2888443#post2888443
lijietz
post on :2005.08.17 12:09
::catagories:
( oracle 技术
)
::reads:(4651)
:: Comments
(2)
::
引用 (0)
