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.148
AA - MM
----------------------
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.148
AA - MM
----------------------