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

I am also facing same problem

Comment on Re^4: [OT] Get the database name in Oracle

Replies are listed 'Best First'.
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]