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

What do database buffers contain?

Define oracle database

What is a SNAPSHOT ?

Why does Oracle not permit the use of PCTUSED with indexes?

What are the oracle differences between nvl and coalesce

What is save point in oracle database?

How to drop a stored procedure in oracle?

What is raw datatype in oracle?

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??

what's query optimization and without use of IN AND Exist can we get another way data from query

What is blob data type in oracle?

For more Oracle General Interview Questions Click Here