From: "Michel Cadot" <micadot@netcourrier.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: v$session.sid
Date: Tue, 10 Oct 2000 14:31:45 +0200
Organization: Guest of France Telecom Oleane's newsreading service
Lines: 17
Message-ID: <8rv297$5lr$1@s1.read.news.oleane.net>
References: <39E308D2.624FB7D7@gazeta.pl>
Reply-To: "Michel Cadot" <micadot@netcourrier.com>
NNTP-Posting-Host: 195.101.229.231
X-Trace: s1.read.news.oleane.net 971181160 5819 195.101.229.231 (10 Oct 2000 12:32:40 GMT)
X-Complaints-To: abuse@oleane.net
NNTP-Posting-Date: Tue, 10 Oct 2000 12:32:40 +0000 (UTC)
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300


select s.sid
from v$session s
where s.audsid = userenv('SESSIONID')
/

--
Have a nice day
Michel


Marcin Buchwald <velvet@gazeta.pl> a écrit dans le message : 39E308D2.624FB7D7@gazeta.pl...
>
> how to select v$session.sid for current session?
>
> I'd like something like 'SELECT SESID FROM DUAL;'