OraFAQ Forum: SQL & PL/SQL » Showing Databases in Server Machine

Home » SQL & PL/SQL » SQL & PL/SQL » Showing Databases in Server Machine

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Showing Databases in Server Machine [message #257761]

Thu, 09 August 2007 02:26

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

Report message to a moderator

Re: Showing Databases in Server Machine [message #257784 is a reply to message #257761]

Thu, 09 August 2007 03:03

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There is none in Oracle unless you call database for schema.

Regards
Michel

Report message to a moderator

Re: Showing Databases in Server Machine [message #257786 is a reply to message #257784]

Thu, 09 August 2007 03:07

challa_shankar
Messages: 16
Registered: August 2007
Location: Hyderabad

Junior Member

Thank u Michel for giving answer.

Thank u very much.

Report message to a moderator

Re: Showing Databases in Server Machine [message #257801 is a reply to message #257761]

Thu, 09 August 2007 03:31

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

From Now on use You instead of "U".

Report message to a moderator

Re: Showing Databases in Server Machine [message #257868 is a reply to message #257761]

Thu, 09 August 2007 07:02

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.

Report message to a moderator

Previous Topic:	Can REF CURSORS be used as IN parameters in STORED procedures
Next Topic:	Need some arithmatic help for this one

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 23:33:52 CST 2024