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

Whether any commands are used for months calculation? If so, what are they?

how to find find & delete duplicate rows from two different tables?

What are the various constraints used in oracle?

What are the execution control statements in oracle?

Is oracle a programming language?

What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

What is trigger associated with the timer ?

How to load data through external tables?

Explain drop constraint oracle?

What are the most common interview questions on ETL Testing for experience?

How to change user password in oracle?

How to export data with a field delimiter?

For more Oracle General Interview Questions Click Here