Re: Current Session Identifier
From: Govindhan Padmavijayam <govind_at_smtskit.attmail.com>
Date: 1996/06/06
Message-ID: <4p7jdp$1c3_at_nntpb.cb.att.com>#1/1
Date: 1996/06/06
Message-ID: <4p7jdp$1c3_at_nntpb.cb.att.com>#1/1
Hi,
You could do this :
select program, process, ....
from V$SESSION
where audsid = userenv('sessionid')
/
. and if it's an interactive SQL session, then add
and terminal = userenv('terminal')
hth,
Govind. Received on Thu Jun 06 1996 - 00:00:00 CEST