This is probably a very elementary question. I would like to have an sql
which returns the name of the Oracle server and the current database. Could
anybody help me out?

Regards,
Richard

Server name etc.:
http://www.orafaq.com/scripts/sql/ver.txt

Current database.:
http://www.orafaq.com/scripts/sql/whoami.txt


// Soeren

Thanks, Soeren. I found the last link helpful, but I don't see that the
first one really tells you how to obtain the name of the server?

"Soeren Degn Jahns" <nospam (AT) nospam (DOT) dk> wrote

Hi Richard. Yeah, you're right. I was a bit too fast there, sorry. Would,
what you are looking for, be the global_name then:
SELECT global_name FROM global_name ;

This would be equivialent to:
SELECT ora_database_name FROM dual;

Hope this helps?

// Soeren

"Soeren Degn Jahns" <nospam (AT) nospam (DOT) dk> wrote

Richard, you can find the database name in v$database while the
machine name for both the front-end and Oracle session background
processes can be found in v$session. The dynamic performance views,
v$..., are documented in the Oracle version# Reference Manual.

The sys_context function is a handy source of information about the
current session including Oracle username, Os user, Proxy user, IP
address, .... See the SQL Manual.

HTH -- Mark D Powell --