From: svemulapalli@my-deja.com
Newsgroups: comp.databases.oracle.misc
Subject: Re: v$session.sid
Date: Tue, 10 Oct 2000 12:49:04 GMT
Organization: Deja.com - Before you buy.
Lines: 43
Message-ID: <8rv37v$um0$1@nnrp1.deja.com>
References: <39E308D2.624FB7D7@gazeta.pl>
NNTP-Posting-Host: 208.17.213.42
X-Article-Creation-Date: Tue Oct 10 12:49:04 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
X-Http-Proxy: 1.1 x72.deja.com:80 (Squid/1.1.22) for client 208.17.213.42
X-MyDeja-Info: XMYDJUIDsvemulapalli


Hi,
i think following query will help you
select sid from v$session where username=(select user from dual);
Suresh

In article <39E308D2.624FB7D7@gazeta.pl>,
  Marcin Buchwald <velvet@gazeta.pl> wrote:
> This is a multi-part message in MIME format.
> --------------99CA7113CADA1FC62226FD3C
> Content-Type: text/plain; charset=iso-8859-2
> Content-Transfer-Encoding: 7bit
>
> how to select v$session.sid for current session?
>
> I'd like something like 'SELECT SESID FROM DUAL;'
> --------------99CA7113CADA1FC62226FD3C
> Content-Type: text/x-vcard; charset=iso-8859-2;
>  name="velvet.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Marcin Buchwald
> Content-Disposition: attachment;
>  filename="velvet.vcf"
>
> begin:vcard
> n:Buchwald;Marcin
> tel;home:0605 696 932 / 66807
> tel;work:+48 22 555-6158
> x-mozilla-html:FALSE
> org:Agora SA;IT Department
> adr:;;;;;;
> version:2.1
> email;internet:velvet@gazeta.pl
> title:Database Programist
> fn:Marcin W. Buchwald
> end:vcard
>
> --------------99CA7113CADA1FC62226FD3C--
>
>


Sent via Deja.com http://www.deja.com/
Before you buy.