how do get database name at sql prompt?

Question Posted / jakki

3 Answers
7027 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

Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?

2 Answers IBM,

What is meant by redo log buffer ?

2 Answers

What is the data pump import utility?

0 Answers

How many types of tables are there in oracle?

0 Answers

Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?

1 Answers

How to get a list of all background sessions in the database?

0 Answers

Explain user account with reference to oracle.

0 Answers

When a form is invoked with call_form, Does oracle forms issues a save point ?

1 Answers Oracle,

various types of joins

9 Answers

what is the difference between primary key & foreign key?

57 Answers CTS, Infosys, La Multi, Sparsh, Wipro,

diff between DELETE and TRUNCATE?.

14 Answers HCL, Yalamanchili Software,

What is ASM (Automatic Storage Management) in Oracle?

0 Answers MCN Solutions,

For more Oracle General Interview Questions Click Here