how do get database name at sql prompt?

Question Posted / jakki

Answers were Sorted based on User's Feedback

how do get database name at sql prompt?..

Answer / mkumar.it

select name from v$database

Is This Answer Correct ?

14 Yes

0 No

how do get database name at sql prompt?..

Answer / harikiran

select ora_database_name from dual

Is This Answer Correct ?

3 Yes

1 No

how do get database name at sql prompt?..

Answer / jinesh

thnks

Is This Answer Correct ?

1 Yes

3 No

More Oracle General Interview Questions

Can multiple cursors being opened at the same time?

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

How to login to the server without an instance?

How to load excel data sheet to oracle database

what r routers?

create one table to capture an employee details with a primary key.

How do I connect to oracle database?

what is data independence exactly? give an example

What are the trigger associated with image items ?

What are the various oracle database objects?

how to find count rows in table without count function?

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

For more Oracle General Interview Questions Click Here