Re^2: [OT] Get the database name in Oracle

Replies are listed 'Best First'.
Re^3: [OT] Get the database name in Oracle by Anonymous Monk on Dec 22, 2008 at 10:31 UTC
it is not working for me! :( Here is the output when I tried in SQL plus window: SQL> select name from v$database; select name from v$database * ERROR at line 1: ORA-00942: table or view does not exist	[reply]
Re^4: [OT] Get the database name in Oracle by Anonymous Monk on Dec 16, 2010 at 20:43 UTC
You don't have the permissions to read v$database. Hint: grant select to this view or do the "dba" role to user (at your own risk)	[reply]
Re^4: [OT] Get the database name in Oracle by Anonymous Monk on May 30, 2015 at 06:15 UTC
Try this one : select ora_database_name from dual;	[reply]
Re^5: [OT] Get the database name in Oracle by erix (Prior) on May 30, 2015 at 06:34 UTC
You're late, the thread is almost 10 years old, and that answer came in 6 years ago;-)	[reply]
Re^4: [OT] Get the database name in Oracle by Anonymous Monk on Apr 20, 2010 at 00:49 UTC
I am also facing same problem	[reply]
Re^5: [OT] Get the database name in Oracle by Anonymous Monk on Sep 15, 2010 at 19:17 UTC
this view need to be granted from DBA. SELECT SUBSTR (GLOBAL_NAME, 1, INSTR (GLOBAL_NAME, '.') - 1) FROM GLOBAL_NAME ;	[reply]
Re^4: [OT] Get the database name in Oracle by Anonymous Monk on Jun 05, 2012 at 05:31 UTC
You might haven't connected to any database yet.	[reply]