select SYS_CONTEXT('USERENV', 'HOST') as clientname,
utl_inaddr.get_host_address as hostip,
SYS_CONTEXT('USERENV', 'IP_ADDRESS') as clientip
from dual
select SYS_CONTEXT('USERENV', 'HOST') as clientname,
utl_inaddr.get_host_address as hostip,
SYS_CONTEXT('USERENV', 'IP_ADDRESS') as clientip
from dual