Re: oracle user in SQLPLUS

select sid,serial#,audsid,program from v$session where audsid=(select userenv('SESSIONID') from dual);

"darkstar" <chaihock_at_singnet.com.sg> ¼¶¼g©ó¶l¥ó news:al10gh$c47$1_at_mawar.singnet.com.sg...
> how to check the current oracle user in SQLPLUS command?
> what is command for:
> select * from dual;
>
> Thanks.
>
>
Received on Mon Sep 02 2002 - 21:04:31 CDT