How to display databases in Oracle 11g using SQL*Plus

oracle oracle11g sqlplus
Nubkadiya picture Nubkadiya · Jun 9, 2010 · Viewed 409.2k times · Source

With help of this command show databases; I can see databases in MySQL.

How to show the available databases in Oracle?

Answer

Shan picture Shan · Aug 5, 2013

SELECT NAME FROM v$database; shows the database name in oracle

Related questions

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More
PL/SQL ORA-01422: exact fetch returns more than requested number of rows

I get keep getting this error I can't figure out what is wrong. DECLARE * ERROR at line 1: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 11 Here is my code. DECLARE rec_ENAME EMPLOYEE.ENAME%TYPE; …

Read More
TNS Protocol adapter error while starting Oracle SQL*Plus

Whenever I try to login into SQL*Plus (11g Standar Edition Win 64) I get an error related to some connection error. I try to login as sys as sysdba and provide the password. All the services are started. I'm on …

Read More