Re: Getting a Database List

The Oracle instance IS the database.
The MS-SQL equivalent to "database" is TABLESPACE.

As user SYSTEM:

select name from V$TABLESPACE;

"Lee" <lee_at_dev.null.com> wrote in message news:3d3f6464_at_news.starhub.net.sg...
> I need to know the interactive SQL syntax to get a listing of databases on
> the current server.
>
> Using Informix, the commands would be:
> database sysmaster;
> select name from sysdatabases;
>
> MySQL:
> show databases;
>
> MS-SQL:
> SELECT name FROM master..sysdatabases ORDER BY name
>
> Please reply by posting to this newsgroup. My email address is hashed to
> protect me from spamming.
>
> Thanks,
> Lee
>
>
>
>
Received on Thu Jul 25 2002 - 21:18:43 CEST