Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie questions on SQL*Plus

Re: Newbie questions on SQL*Plus

From: Martin Doherty <martin.doherty_at_oracle.com>
Date: Tue, 27 Aug 2002 11:25:00 -0700
Message-ID: <3D6BC3FC.874FEDEA@oracle.com>


Not 100% sure of this, but try

select name from v$database;
show user

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


Received on Tue Aug 27 2002 - 13:25:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US