| Session ID [message #369764] |
Thu, 05 October 2000 17:00  |
Luis Gabriel
Messages: 11
Registered: October 2000
|
Junior Member |
|
|
Hi,
I am trying to do a trigger, who write's to a table information about my actually session, I query the table v$session but if I have two sessions it returns me two rows.
¿Somebody knows how can I get my session ID?
Thanks.
|
|
|
|
| Re: Session ID [message #369768 is a reply to message #369764] |
Fri, 06 October 2000 02:32  |
Prem
Messages: 79
Registered: August 1998
|
Member |
|
|
Luis,
use this select to get your current session id
select userenv('SESSIONID') from dual;
hth
Prem :)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
