Re: Get host name of server from within ORACLE SQL script?

> SELECT *
> FROM v$instance;

specifically,

select host_name from v$instance;

However, you need permissions to get to that view.

Doug

-- 
------------------------
Douglas K. O'Leary
Senior System Administrator
dkoleary_at_mediaone.net