Get host name of server from within ORACLE SQL script?

From: Alastair Cameron <alistair.a.cameron_at_is.shell.com>
Date: Wed, 7 Mar 2001 18:09:45 -0000
Message-ID: <8Pup6.1$ux2.108_at_wwwserv3.shell.nl>

[Quoted] How can I determine the host (or computer) name of the computer where ORACLE [Quoted] 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 [Quoted] name; not the explicit machine name of the host computer.

Thanks. Received on Wed Mar 07 2001 - 19:09:45 CET

This message: [ Message body ]
Next message: Flash: "Oracle Name Server Question"
Previous message: Connor McDonald: "Re: Returning Rows in Random Order"
Next in thread: John Alexander: "Re: Get host name of server from within ORACLE SQL script?"
Reply: John Alexander: "Re: Get host name of server from within ORACLE SQL script?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message