Re: Instance + Hostname

You can use this script/code:

set echo off
--

• Get the host name (see v$instance host_name)
  --
  
• 20041123 Mark D Powell New, save
  --
  column hn format a30 heading "Hostname"

select
utl_inaddr.get_host_name as hn
from
  sys.dual
/

HTH -- Mark D Powell -- Received on Wed Jan 05 2005 - 08:34:18 CST