how do get database name at sql prompt?

how do get database name at sql prompt?

Question Posted / jakki

3 Answers
6357 Views
I also Faced
E-Mail Answers

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

Post New Answer

More Oracle General Interview Questions

What is an oracle database table?

What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?

Is postgres faster than oracle?

What is the difference between a hot backup and a cold backup in oracle?

What is Trigger in Oracle?

0 Answers MCN Solutions,

List the parts of a database trigger.

How many memory layers are in the oracle shared pool?

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

How to convert csv to table in oracle?

Why cursor variables are easier to use than cursors?

What is recovery manager in Oracle?

0 Answers MCN Solutions,

What is literal?

For more Oracle General Interview Questions Click Here

Categories

Oracle General (1808)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241)