oracle how to retrieve sid information
Method 1 (for Oracle 7.x and up)SELECT sid FROM V$SESSION WHERE audsid = userenv('sessionid');
Method 2 (for Oracle 8i and up - uses new function SYS_CONTEXT)
SELECT sid FROM V$SESSION WHERE audsid = SYS_CONTEXT('userenv','sessionid');
posted by James Pei @ 12:34 PM
0 Comments:
Post a Comment
<< Home