aspose file tools*
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
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:

 
It is sorta covered in the JavaRanch Style Guide.
 
subject: How to list all databases in Oracle