Re: Get host name of server from within ORACLE SQL script?
From: John Alexander <jalexander_at_summitsoftwaredesign.com>
Date: Thu, 08 Mar 2001 20:20:24 GMT
Message-ID: <cQRp6.8315$68.1395356_at_typhoon.tampabay.rr.com>
Date: Thu, 08 Mar 2001 20:20:24 GMT
Message-ID: <cQRp6.8315$68.1395356_at_typhoon.tampabay.rr.com>
select host_name
from sys.v_$instance
/
John Alexander
www.summitsoftwaredesign.com
St. Petersburg, FL
Alastair Cameron <alistair.a.cameron_at_is.shell.com> wrote in message
news:8Pup6.1$ux2.108_at_wwwserv3.shell.nl...
> How can I determine the host (or computer) name of the computer where
ORACLE
> server is installed from within a SQLPLUS .SQL script? this applies to
> ORACLE running on UNIX as well as NT, and remote or local connections.
>
> Somebody suggested dbms_utility and port_string, but that returns a
generic
> name; not the explicit machine name of the host computer.
>
> Thanks.
>
>
>
Received on Thu Mar 08 2001 - 21:20:24 CET