Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to get my session id?
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