-
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
-
DB Name
Select Sys.context('userenv','db_name') From Dual;