Re: SID question

> Alexander G Bozhik wrote in message <7m7kuc$8kh$1_at_isd.donin.com>...
> >
> >How can user get SID of his session?

On Sat, 10 Jul 1999, wozi wrote:
>
> select SID from V$SESSION;

Which will give you the session IDs of all the sessions running. Instead, try:

select sid from v$session where audsid = userenv('sessionid');

--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah Received on Sun Jul 11 1999 - 01:00:11 CDT