Re: SessionID

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 24 Mar 2003 17:25:51 -0800
Message-ID: <2687bb95.0303241725.a68f81@posting.google.com>

Claire <claire.chan_at_t-online.de> wrote in message news:<3E7F62FF.1000902_at_t-online.de>...
> Hi,
>
> Can somebody tell me what select statement will show me my sesssion id?
>
> thankful newbie,
> Claire Chan

Try:
select sid from v$mystat where rownum = 1;

You need to have DBA, select any table, or select catalog to query the v$ dynamic performance views.

HTH -- Mark D Powell -- Received on Mon Mar 24 2003 - 19:25:51 CST