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

Home -> Community -> Usenet -> c.d.o.server -> Re: Determining UNIX hostname from PL/SQL

Re: Determining UNIX hostname from PL/SQL

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Mon, 01 Feb 1999 23:38:20 +0000
Message-ID: <36B63AEC.80C8E0A6@rdbms.freeserve.co.uk>


Tim,

You might want to try

SELECT host_name
FROM v$instance;

Chris.

ps on closer investigation both host_name and machine are of type varchar2(64)....

tdry_at_brls.com wrote:
>
> Is there a good way of determinig the name of a UNIX host from within
> PL/SQL code?
Received on Mon Feb 01 1999 - 17:38:20 CST

Original text of this message

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