Re: How can I get a transaction's session id from inside the transaction ?

JusungYang_at_yahoo.com (Jusung Yang) wrote in news:130ba93a.0210141154.18e69e6_at_posting.google.com:

> ???
>
> Can you take one more look of your query and explain a bit?
>
> - Jusung Yang
>
>
> Ban Spam <ban-spam_at_operamail.com> wrote in message

>> select sid from v$mystats
>> where rowid = 1;

SQL> DESC V$MYSTATS

-- do it your self & what do you see?
-- it does exactly what you requested.
-- it returns the SID of the session invoking the query.