Home » SQL & PL/SQL » SQL & PL/SQL » Showing Databases in Server Machine
Showing Databases in Server Machine [message #257761] Thu, 09 August 2007 02:26 Go to next message
challa_shankar
Messages: 16
Registered: August 2007
Location: Hyderabad
Junior Member
Hi,

I am using Oracle 10g. I'm trying to find a query for Oracle to retrieve the available databases, just like mysql has "SHOW DATABASES". But I just can't seem to find it in their horrific huge documentation section. Can somebody help me?

I am using Oracle 10g
Version- Oracle SQL* Plus Version 10.2.0.1.0
OS-WindowsXP


Thank u...!
Ravi
Re: Showing Databases in Server Machine [message #257784 is a reply to message #257761] Thu, 09 August 2007 03:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64138
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is none in Oracle unless you call database for schema.

Regards
Michel
Re: Showing Databases in Server Machine [message #257786 is a reply to message #257784] Thu, 09 August 2007 03:07 Go to previous messageGo to next message
challa_shankar
Messages: 16
Registered: August 2007
Location: Hyderabad
Junior Member
Thank u Michel for giving answer.

Thank u very much.
Re: Showing Databases in Server Machine [message #257801 is a reply to message #257761] Thu, 09 August 2007 03:31 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

From Now on use You instead of "U".
Re: Showing Databases in Server Machine [message #257868 is a reply to message #257761] Thu, 09 August 2007 07:02 Go to previous message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
And I do believe that an Oracle Schema is the same as a MySql database.
Previous Topic: Can REF CURSORS be used as IN parameters in STORED procedures
Next Topic: Need some arithmatic help for this one
Goto Forum:
  


Current Time: Thu Dec 08 06:36:46 CST 2016

Total time taken to generate the page: 0.11483 seconds