Re: v$session.sid

From: Marc Billiet <someone.overthere_at_living>
Date: Wed, 11 Oct 2000 05:32:17 GMT
Message-ID: <20001011.5321747@slu40xxx.hae.hydro.com>

Unfortunately, this doesn't seem to work in a database job (at least wit h
Oracle 7.3.4.4.0). But in that case, you can use

select sid
from v$mystat
where rownum = 1

Marc

>>>>>>>>>>>>>>>>>> Oorspronkelijk bericht <<<<<<<<<<<<<<<<<<

Op 2000-10-10, 14:31:45, schreef "Michel Cadot" <micadot_at_netcourrier.com
>

over het thema 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...
> >
> > how to select v$session.sid for current session?
> >
> > I'd like something like 'SELECT SESID FROM DUAL;'
Received on Wed Oct 11 2000 - 00:32:17 CDT