How to list all databases in Oracle

[Madhu Kaparapu]

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

[Dave Salter]

You can do this with:

select * from user_tablespaces;