Re: How to get session number?

In a previous article, lanclosd_at_bcstec.ca.boeing.com (Dwayne K. Lanclos) says:

>If I'm in PL/SQL, how do I obtain the current session ID?

    SELECT SID

       FROM V$SESSION
       WHERE AUDSID = USERENV("SESSIONID");

   Note that the special function USERENV() can be used to obtain other neat things. See your SQL Language Reference for more fun stuff.

• Doug --