Re: v$session.sid

From: <svemulapalli_at_my-deja.com>
Date: Tue, 10 Oct 2000 12:49:04 GMT
Message-ID: <8rv37v$um0$1@nnrp1.deja.com>

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

In article <39E308D2.624FB7D7_at_gazeta.pl>, Marcin Buchwald <velvet_at_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_at_gazeta.pl
> title:Database Programist
> fn:Marcin W. Buchwald
> end:vcard
>
> --------------99CA7113CADA1FC62226FD3C--
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 10 2000 - 07:49:04 CDT