Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: SQL*Plus question (Where am I)
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