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:13:15 -0000
Message-ID: <qSup6.4$ux2.100_at_wwwserv3.shell.nl>
Date: Wed, 7 Mar 2001 18:13:15 -0000
Message-ID: <qSup6.4$ux2.100_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 Wed Mar 07 2001 - 19:13:15 CET