Re: Session ID determination

From: cf <news_at_sitinfo.com>
Date: Fri, 31 Aug 2001 15:28:00 +0200
Message-ID: <9mo531$bh8$1@reader1.fr.uu.net>

try this :

select distinct sid from sys.v_$mystat;

"Matteo Vitturi" <mvitturi_at_libero.it> a écrit dans le message news: eb141852b8b0eae8f3f9a73adbcf4d13.16982_at_mygate.mailgate.org...
> Hello all!
>
> Is there any simple way to determine the ID of the session
> I am running on?
>
> I know I can select from v$session and look for it, but
> what I'm looking for is something like a pseudocolumn
> so it's easy to be accessed from any PL/SQL or SQL.
>
> Regards.
> Matteo Vitturi
>
> --
> Posted from [213.82.64.18]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Fri Aug 31 2001 - 08:28:00 CDT