How to display databases in Oracle 11g using SQL Plus

Question

I can see MySQL databases by using the command show databases.

How does Oracle display the accessible databases?

Answer 1

A MySQL "database" can be compared to an Oracle schema or user. You can search the DBA USERS view to see a list of schemas if you have the necessary privileges:

SELECT * FROM DBA_USERS;

I hope this helps you.