Re: Getting a Database List

In Oracle you don't have such a command. You can however see the name of the db that you're connected to, by issuing: select name from v$database;

Hope this helps.

Alex

"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 - 06:48:16 CEST