Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to get my session id?

Re: How to get my session id?

From: Biju Thomas <bijuthomas_at_email.msn.com>
Date: Tue, 4 Aug 1998 19:57:15 -0500
Message-ID: <OrhTFwAw9GA.192@upnetnews03>


Try this...

SQL> select audsid, sid, serial#, username   2 from v$session
  3 where audsid = userenv('SESSIONID');

--
Thanks,
Biju Thomas

For Oracle Scripts, Tips and Links
http://www.geocities.com/SiliconValley/Peaks/4535/oracle_main.htm Received on Tue Aug 04 1998 - 19:57:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US