Re: whoami

Umar FArooq <umar.farooq_at_cressoft.com.pk> escribió en artículo <35655991.15EA4CC6_at_cressoft.com.pk>...
> is there a command (or column of a view/table) in oracle equivalent to
> the 'whoami' unix command
>
> THx.
>
>

 Option 1.

• If you want use in PL/SQL program can use :

select user into user_name_variable from dual;

 Option 2.

• An equivalent select in SQLPLUS

SQLPLUS> select user from dual;

Option 3.

• If you only want knowon what user are you connected can use :

SQLPLUS> show user

Leonel Sanhueza
Universidad de Concepcion
Chile. Received on Mon May 25 1998 - 21:03:59 CDT