File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Oracle/OAS and the fly likes How to list all databases in Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "How to list all databases in Oracle" Watch "How to list all databases in Oracle" New topic

How to list all databases in Oracle

Madhu Kaparapu
Ranch Hand

Joined: Jul 04, 2005
Posts: 35
Sorry for the mistake leave the earlier topic;

I have to show all the database in oracle
in Mysql we have the query that shows all the databases
mysql> show databases;
like that i have to list all the databases in oracle
i don't know the query please let me know

Madhu Kaparapu.
Dave Salter
Ranch Hand

Joined: Jul 20, 2005
Posts: 292

You can do this with:

I agree. Here's the link:
subject: How to list all databases in Oracle
Similar Threads
Is Noscroll a Database?
Collection as a parameter in a Callable Statement
List all databases present in Oracle
getting list of table names in Oracle and MySQL
SQL command to show tables