Re: How to get hostname in PL/SQL

Try this:
SELECT HOST_NAME FROM v$instance;

Olivier Bercovitz wrote in message <9308ok$qeq$1_at_front5.grolier.fr>...
>Hello everybody,
>
>Is there a way to know the hostname (or the IP adress) in a PL/SQL
 procedure
>(throught a specific variable ?? or a package??) and without using the
>extproc feature of O8i ??
>Thanks in advance
>BR
>Olivier
>
>
Received on Wed Jan 03 2001 - 17:44:32 CST