Re: need ip Address from Hostname !!

From: Vadim Grepan <kezal_at_mail.ru>
Date: Thu, 17 Jan 2002 16:12:27 +0300
Message-ID: <3C46CDBB.728BAC81@mail.ru>

hello!

You can try:

select sys_context ('USERENV', 'IP_ADDRESS') from dual;

Rgds, Vadim Grepan

---

Moscow, Russia

thierry britschu wrote:

> Hi
>
> I am working in a project were we need to read from Oracle (8i)
> Database, using PL/SQL, all Client Sessions environment Informations
> like ip Address or local Hostname.
> I can read the Client "Local hostname" from the Table V$SESSION colunm
> Terminal
> How can I obtain the ip address ?
>
> Hopefully someone can provide some ideas or assistance with this
> issue.
>
> Thanks in advance,
>
> Thierry
Received on Thu Jan 17 2002 - 07:12:27 CST