Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: v$session.sid

Re: v$session.sid

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Tue, 10 Oct 2000 14:31:45 +0200
Message-ID: <8rv297$5lr$1@s1.read.news.oleane.net>

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...

>
> how to select v$session.sid for current session?
>
> I'd like something like 'SELECT SESID FROM DUAL;'
Received on Tue Oct 10 2000 - 07:31:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US