Concepts and Architecture Interview Question:

Explain what is the command to find the database that already present before connecting?

Submitted by: Administrator

As a sys or system user,select name from v$database;As a normal user,select global_name from global_name;select ora_database_name from dual; - dual is a dummy table in oracleshow parameter db_name - has to be given in sql prompt.
Submitted by: Administrator