Current DB_NAME

[Shanki Narayanan]

Hi !!!

How do i get the current database name.

I tried the following query

select name from v$database;

but this works only for users with sysdba rights. Let me know the way to get the name of database, connected as a normal user.

Thanks

[Avi Abrami]

Shanki,
A quick search of the "comp.databases.oracle.server" newsgroup archives reveals the following discussion which (among other things) suggests the following:

select sys_context('userenv','db_name') from dual

Hope it helps.

Good Luck,
Avi.
[ June 02, 2005: Message edited by: Avi Abrami ]

[Shanki Narayanan]

Avi,

Thanks !!! it did help

Cheers
Shanki