How to know client ipaddress in Oracle.

You can use this query to get Client IPAddress in Oracle.

Command:
select sys_context('userenv','ip_address') from dual;

Result:
192.168.1.1



Ref: http://forums.oracle.com/forums/thread.jspa?messageID=1562503

==TaTsHuYa==