use sys_context to find ip address.


try this query

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