Re: How to get my session id?

Hello,

    I supouse that you have not been granted on v$session. If I am right, is quite dificult to get the sid number.

    If you have grants on the system views, only qwery this:

       select username,sid from v$session where username=<your user name>;

    Nice to help you, Juan Carlos

In article <35C75C76.C89FF397_at_hk.super.net>,   kelvinng_at_POBoxes.com wrote:
> Hello,
>
> I would like to know that how can I obtain my session id by using
> SQL or by any pseudo-column.
>
> Thank you for your ssuggestion and attention.
>
> Kelvin Ng
>
> --
> =============================================================
> # Home Page : http://welcome.to/kelvinng
> # My PGP Public Key : http://www.hk.super.net/~kingmang/pgpkeys.html
> =============================================================
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Aug 07 1998 - 03:00:03 CDT