- 博客(1)
- 资源 (10)
- 收藏
- 关注
RSS订阅转载 USERENV 和 sys_context
<br />这两个函数用来记录连接的session信息，经常用于触发器中，记录客户端的连接信息（比如IP）。我比较关注的是sessionid和 ip，但是 select userenv('sessionid')得到的并不是用户的sid，而是v$session中的audsid，sid根据audsid再得到：<br /> SQL> select sid from v$session where audsid=userenv('sessionid');<br /> SID<br /> ----------<
2010-11-24 10:37:00
404
1
asp.net asp.net.
asp.net.asp.net.asp.net.asp.net.asp.net.asp.net.asp.net.asp.net.asp.net.asp.net.asp.net.asp.net.asp.net.asp.net.asp.net.asp.net.
2011-04-08
myself linu x(2)
myself linu x(2)myself linu x(2)myself linu x(2)myself linu x(2)myself linu x(2)
2010-12-31
my self Csharp_4the(8)
my self Csharp_4the(8)my self Csharp_4the(8)my self Csharp_4the(8)
2010-12-29
my self Csharp_4the(7)
my self Csharp_4the(7)my self Csharp_4the(7)my self Csharp_4the(7)
2010-12-29
my self Csharp_4the(6)
my self Csharp_4the(6)my self Csharp_4the(6)my self Csharp_4the(6)
2010-12-29
my self Csharp_4the(5)
my self Csharp_4the(5)my self Csharp_4the(5)my self Csharp_4the(5)
2010-12-29
my self Csharp_4the(4)
my self Csharp_4the(4)my self Csharp_4the(4)my self Csharp_4the(4)
2010-12-29
my self Csharp_4the(3)
my self Csharp_4the(3)my self Csharp_4the(3)my self Csharp_4the(3)
2010-12-29
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人