How to find out the database name from SQL*PLUS command prompt?

Questions by Beena   answers by Beena

Showing Answers 1 - 9 of 9 Answers

Levey

  • Oct 3rd, 2005
 

SELECT INSTANCE_NAME from V$INSTANCE;

Jayakumar M

  • Nov 8th, 2005
 

Select * from v$database;

  Was this answer useful?  Yes

Nagarjuna Reddy

  • Jan 9th, 2006
 

Select * from global_name;

This will give the datbase name which u r currently connected to.....

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions