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 is a Database instance ? Explain?

What privilege is needed for a user to create views in oracle?

Explain the use of record option in exp command.

what are different types of locks?

How do I connect to oracle database?

Explain integrity constraints?

What is an anonymous block?

can you explain performance tunning in oracle(sql,PL/SQL)

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.

What is the difference between a user and a schema in oracle?

What is a Sequence ?

For more Oracle General Interview Questions Click Here