Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: v$session.sid
select s.sid
from v$session s
where s.audsid = userenv('SESSIONID')
/
-- Have a nice day Michel Marcin Buchwald <velvet_at_gazeta.pl> a écrit dans le message : 39E308D2.624FB7D7_at_gazeta.pl...Received on Tue Oct 10 2000 - 07:31:45 CDT
>
> how to select v$session.sid for current session?
>
> I'd like something like 'SELECT SESID FROM DUAL;'