Re: How to identify my session?

Hi

Issue the following statement to find out your session id

select userenv('sessionid') from dual

Regards

N.Prabhakar

Brahms Lin wrote:

> Hi,
>
> I would like to find some way to identify my Oracle app's session.
> I know there's a v$session, but don't know which is my current
> session. I'm trying to generate an unique table name. I think that
> can be done by prefixing the current session's id to the table name.
>
> Thanks.
>
> (Oracle 8.0.4 on NT workstation 4.0)

Received on Wed May 05 1999 - 04:01:11 CDT