Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: IP of the current instance/DB
Rauf Sarwar wrote
> select utl_inaddr.get_host_address -- (IP Address)
> from dual;
>
> select utl_inaddr.get_host_name -- (Host name)
> from dual;
>
> Note: For this function call to work in 8.1.7.x, you need to have
> ORACLE_HOME/plsql/jlib/plsql.jar installed in the database.
>
> Regards
> /Rauf
thanks ! Received on Tue Nov 23 2004 - 13:58:15 CST