Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sql command to list all databases in the oracle server

Re: sql command to list all databases in the oracle server

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 29 Dec 2006 08:57:41 -0800
Message-ID: <1167411455.182468@bubbleator.drizzle.com>


dalu.gelu_at_gmail.com wrote:
> Hi,
>
> could u help me, what is the sql command to list all existing databases
> in a oracle server?

Oracle IS NOT SQL Server
Oracle IS NOT Sybase
Oracle IS NOT Informix
Oracle IS NOT Ingres

Thus your question has no meaning.

In Oracle a "database" is a set of related physical files sitting on disk. It has nothing to do with the use of that word in other products.

The word you are looking for is SCHEMA and the query you are asking for is:

SELECT username, account_status
FROM dba_users
ORDER BY 1; For more information try the following:
http://tahiti.oracle.com
http://www.psoug.org (and click on Morgan's Library)

HTH

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Dec 29 2006 - 10:57:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US