Re: Session ID determination

From: CHC <qi.xiang.chi_at_icu.nl>
Date: Sun, 16 Sep 2001 10:14:11 +0200
Message-ID: <9o1mv6$1b73$1@beast.euro.net>

How about:
select userenv('sessionid') from dual;

Regards

Matteo Vitturi <mvitturi_at_libero.it> wrote in 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 Sun Sep 16 2001 - 03:14:11 CDT