Re: Newbie questions on SQL*Plus

Carlos Oliveira wrote:

> Hello,
>
> Two simple questions: on SQL*Plus prompt under Linux, how can i know in which database i'm working and how can i know the user name?
>
> Thank you very much in advance
>
> Cheers
>
> Carlos

SELECT USER FROM dual;

SELECT name FROM v_$database;

Daniel Morgan Received on Tue Aug 27 2002 - 14:56:03 CDT