How to get host IP in oracle

select utl_inaddr.get_host_address(host_name), host_name from
v$instance;