Thursday, December 9, 2010
Wednesday, December 1, 2010
Monday, November 8, 2010
How to find current session ID
How to find current session ID
Way1: select sid from v$session where sid=(select sid from v$mystat where rownum =1);
Way2: select sid from v$session where audsid = sys_context('userenv','sessionid');
Way3: If DBMS_SUPPORT is installed,select dbms_support.mysid from dual;
Way1: select sid from v$session where sid=(select sid from v$mystat where rownum =1);
Way2: select sid from v$session where audsid = sys_context('userenv','sessionid');
Way3: If DBMS_SUPPORT is installed,select dbms_support.mysid from dual;
Sunday, October 31, 2010
Subscribe to:
Posts (Atom)