Re: Select Current Session ID ?
Date: Mon, 11 Feb 2008 12:36:25 -0800 (PST)
On Feb 11, 7:08 am, Cassiano <cassianorol..._at_gmail.com> wrote:
> How I can select *my* current session id (from v$session?) in sqlplus?
Apart from using the v$mystat view (available in 9i and later releases)
where audsid = sys_context('USERENV', 'SESSIONID');
Presuming you have access to the V$SESSION view.
David Fitzjarrell Received on Mon Feb 11 2008 - 14:36:25 CST