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

how to find full database size

what is the exact definition for pointer?

What is recovery manager(rman) backup in Oracle?

What is hot backup and logical backup?

how to unbreak sequence numbers during intereptions

find the second highest salary of the emp table

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

Differentiate between function and procedure in oracle.

please explain.. DB architecture ...

What is proxy method?

ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?

What is a subquery in oracle?

For more Oracle General Interview Questions Click Here