Hostname using SQL statement

[cogcheck]

Hi,
Is there a way to identify the hostname of the database using a SQL statement, if yes will be glad if you could share the same with me.

Thanks in advance

[Srinivas_Sharma]

select sys_context('userenv','host') from dual;

Returns : Name of the host machine from which the client has
connected.

is tht what u want...

if u want to know the hostname where the db is running....then

it will be select host_name from v$instance;

Srini