This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets 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
Author

How to list all databases in Oracle

Madhu Kaparapu
Ranch Hand

Joined: Jul 04, 2005
Posts: 35
Hai
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


Regards,
Madhu Kaparapu.
Dave Salter
Ranch Hand

Joined: Jul 20, 2005
Posts: 292

You can do this with:

 
Consider Paul's rocket mass heater.
 
subject: How to list all databases in Oracle
 
Similar Threads
Collection as a parameter in a Callable Statement
List all databases present in Oracle
SQL command to show tables
Is Noscroll a Database?
getting list of table names in Oracle and MySQL