Re: How to find PID in a session

From: Werner <werner.smit_at_face.co.zackityspam>
Date: Wed, 03 Mar 1999 10:07:46 +0200
Message-ID: <36DCEDD2.758D@face.co.zackityspam>

Thanks Jonathan

It seems to be exactly what i needed!!

Of course one tends to wonder what other goodies hide behind this "Userenv" function ?

I looked it up on the web and found..

select userenv('sessionid'),
       userenv('label'),
       userenv('language'),
       userenv('terminal'),
       userenv('entryid')  from dual;

thanks again

Jonathan Lewis wrote:
>
> select userenv('sessionid') from dual;
>
> is usually adequate.
>
> --
> Jonathan Lewis
> Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
Received on Wed Mar 03 1999 - 02:07:46 CST