Re: whoami

From: Joel R. Kallman <jkallman_at_us.oracle.com>
Date: Fri, 22 May 1998 15:53:33 GMT
Message-ID: <35669eed.19828892@newshost.us.oracle.com>

"SHOW USER" is only valid in the context of using SQL*Plus. You cannot use "SHOW USER" in Server Manager, nor can you use it programatically. "SELECT USER FROM DUAL" can be used in SQL*Plus, Server Manager, and PL/SQL.

On Fri, 22 May 1998 14:03:51 GMT, "Pierre" <proussin_at_tactik.com> wrote:

>
>Joel R. Kallman wrote in message
><35657dd6.11357270_at_newshost.us.oracle.com>...
>>"SELECT USER FROM DUAL" should do the trick.
>
> SHOW USER is shorter.
>>
>>On Fri, 22 May 1998 15:55:13 +0500, Umar FArooq
>><umar.farooq_at_cressoft.com.pk> wrote:
>>
>>>is there a command (or column of a view/table) in oracle equivalent to
>>>the 'whoami' unix command
>>>
>>>THx.
>>>
>>
>>Thanks!
>>
>>Joel
>>
>>Joel R. Kallman
>>Oracle Government, Education, & Health
>>Columbus, OH http://govt.us.oracle.com
>>jkallman@us.oracle.com http://www.oracle.com
>>
>>----
>>The statements and opinions expressed here are my own
>>and do not necessarily represent those of Oracle Corporation.
>
>

Thanks!

Joel

Joel R. Kallman Oracle Government, Education, & Health

Columbus, OH                             http://govt.us.oracle.com

jkallman@us.oracle.com                   http://www.oracle.com

---

The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Received on Fri May 22 1998 - 10:53:33 CDT