How to get server IP or host IP from ORACLE???

select  UTL_INADDR.get_host_address('mypc1') from dual;

SELECT UTL_INADDR.get_host_name('192.168.0.1') FROM dual;