Re: Basic SQL Command

From: Chris Rizzo <abcd_at_efgh.com>
Date: Wed, 31 Jan 2001 07:55:25 -0500
Message-ID: <OUpceS4iAHA.272_at_cpmsnbbsa09>


Oh, now I understand... sorry.

I'm not sure, but try the following:

SELECT name FROM v$database

at the SQLPlus prompt.

HTH "Nicolas Boseret" <nicolas.boseret_at_be.origin-it.com> wrote in message news:0E16861EE7BCD111BE9400805FE6841F142DB186_at_c1s5x001.cor.srvfarm.origin-it .com...
> Ok Thanks,
> but what if I'm logging on Oracle without knowing what are the databases
> defined in it ... Is there a general table which I can select to get all
> databses names ...
>
> Many thanks,
>
> Nicolas.
>
>
>
Received on Wed Jan 31 2001 - 13:55:25 CET

Original text of this message