Re: Database names?

From: Manu <manu_at_keltika.net>
Date: Wed, 19 Feb 2003 12:20:10 +0100
Message-ID: <b2vord$g19$1@fata.cs.interbusiness.it>

"James" <james_at_nothing.com> wrote in message news:1045650195.584305_at_ftp.adept.co.za...
> Hi there
> Can someone tell me how I can get the names of all the Databases on a
> server? I understand that the that the database structure of a n oracle
> server is very different to a SQL server.
>
> I wand to be able to determin all the names of all the database on the
> server that I'm working with.
> I'm using oracle 9i server and have full rights to the server!
>
> Hope someone can help.
> Thanks in Advance
> cheers
> James
>
>

This is the select that gives you the name of all users of your database:

SELECT USERNAME FROM ALL_USERS; bye bye

Emanuela Received on Wed Feb 19 2003 - 05:20:10 CST