Re: Get host name of server from within ORACLE SQL script?

> 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.

SELECT *
FROM v$instance;

You will find what you seek.

Daniel A. Morgan Received on Thu Mar 08 2001 - 00:06:30 CST