Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: IP of the current instance/DB

Re: IP of the current instance/DB

From: robert <rchin_at_nietspampanix.com>
Date: Tue, 23 Nov 2004 14:58:15 -0500
Message-ID: <co04op$kp$1@reader1.panix.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US