Re: (no subject)

> yusri bidin <yusri_at_sapura1.po.my> writes:
> Does somebody knows how to get your own
> session id and serial# when you logon
> eg. select sid from dual?
>
> Thanks.
>
>
>
>>>>

Try something like

select userenv('sessionid') from dual;

This will return the audit session id of the current session.

Or, you can do something like:

select sid, osuser, etc from v$session where audsid = userenv('sessionid');

Will Kooiman Received on Sun Aug 20 1995 - 00:00:00 CEST