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 define a specific record type?

What is the quickest way to fetch the data from a table?

How to display the hierarchy of employee and managers without using connect by prior.

How to check the oracle tns settings?

How to declare a local variable?

What are the different types of failures that occur in Oracle database?

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

What is ordinary table in oracle?

What is the difference between translate and replace in oracle?

How to create a new view in oracle?

How to manage transaction isolation level?

Can multiple cursors being opened at the same time?

For more Oracle General Interview Questions Click Here