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

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