Wednesday, December 05, 2007

How to see the IP of a computer from SQL in Oracle

SQL> select sys_context('userenv','ip_address') from dual;

SYS_CONTEXT('USERENV','IP_ADDRESS')
--------------------------------------------------------------------------------
120.0.0.11

SQL>

1 comment:

Archana said...

This is really Useful