HOST_NAME & HOST_ADDRESS FINDING_QUREY

select utl_inaddr.get_host_name FROM dual;

select utl_inaddr.get_host_address FROM dual;