Re: Database names?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 20 Feb 2003 00:02:59 +1000
Message-ID: <ZYK4a.51069$jM5.128737@newsfeeds.bigpond.com>

"Richard Ward" <Richard_at_ctcal.ctech.ac.za> wrote in message news:b2vntc$2dbm$1_at_news.adamastor.ac.za...
> For Oracle 7.3.4 (heh) probably will work on all versions though.
> try:
> select table_name from all_tables;
>
> Should give you a list of all the tables in the DB.
> do also:
> desc all_tables;
> and modify the first select to suit.
>

Hi Richard I,

This won't exactly give you a list of all the "databases" on the server ...

See Kantix's post.

Cheers

Richard II Received on Wed Feb 19 2003 - 08:02:59 CST