Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Instance + Hostname

Re: Instance + Hostname

From: ana <anacedent_at_hotmail.com>
Date: Wed, 5 Jan 2005 13:52:46 -0800
Message-ID: <3435sfF45pdmlU1@individual.net> 





"Zephyr" <p.neumann_at_ids-scheer.de> wrote in message
news:41dbf9ec$0$5320$4d4ebb8e_at_read-nat.news.de.uu.net...


> How can I get the hostname of a machine that hosts an ORACLE 9i instance,

> to use it inside a PL/SQL block. I get the instance name from global_name

> all

> needed params of the userenvironment within userenv, but how do I get the

> hostname?




SELECT MACHIINE FROM V$SESSION WHERE SID=1;

Received on Wed Jan 05 2005 - 15:52:46 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US