CODEWITHSUNDEEP
sqloracle-databasesqlplus
Tak
Tak

Reputation: 3616

Select the Database name in iSQL plus

I have a database but I don't know it's name, and I'm wondering how I can know it using iSQL Plus. So if anyone could please advise.

Upvotes: 1

Views: 514

Answers (1)

Sylvain Leroux
Sylvain Leroux

Reputation: 51980

Once connected to your RDBMS, you can issue the following command to query the database name:

select ora_database_name from dual;

On my system:

SQL> select ora_database_name from dual;

ORA_DATABASE_NAME
--------------------------------------------------------------------------------
XE

Upvotes: 2

Related Questions