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

Home -> Community -> Usenet -> c.d.o.tools -> Re: SQL*Plus question (Where am I)

Re: SQL*Plus question (Where am I)

From: Reinier <Reinier_Dickhout_at_hetnet.nl>
Date: Mon, 2 Oct 2000 08:23:12 +0200
Message-ID: <#o75llDLAHA.162@net025s>

Or if you don't have any priviliges for that view,

select * from global_name;

Reinier.

Andy Collins <andy.collins_at_clara.co.uk> wrote in message news:LBNB5.7770$j4.548374_at_nnrp3.clara.net...
> Frank,
>
> SELECT name FROM v$database;
>
> Andy.
>
> Frank Cornacchiulo <fjcorn_at_mindspring.com> wrote in message
> news:8r81k3$suf$1_at_slb6.atl.mindspring.net...
> > At the SQL*Plus prompt, is there a way of finding out what database I am
> > logeed into?
> >
> > Thanks,
> > FC
> >
> >
>
>
Received on Mon Oct 02 2000 - 01:23:12 CDT

Original text of this message

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