Database name

Hi,

I am a newbe in Oracle, i have managed to install oracle on to my machine and logged on to SQL*Plus. I have configured the service name to connect to the database on the Server, but i now want to display the database name through SQL*Plus. All I need is to display the database name from SQL*Plus.

Thank you in advance.

Regards

MM

Tips & Tricks?...

show parameter db_name

or

select name from v$database;

Select * from v$instance ;
select * from v$database;
select * from global_name ;

Use whatever you need

Select Sys.context('userenv','db_name') From Dual;