SQL> select utl_inaddr.get_host_address from dual;
GET_HOST_ADDRESS
----------------------------------------------------------------------------------------------------
193.175.232.59
SQL
> select sys_context('userenv','ip_address') cliaddress,2 sys_context('userenv','terminal') terminal
3 from dual
; CLIADDRESS ---------------------------------------------------------------------------------------------------- TERMINAL ---------------------------------------------------------------------------------------------------- 10.6.8.148AA
-MM ----------------------