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

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

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

for ORACLE 11g with data vault :-

SELECT GET_FACTOR('DATABASE_IP') FROM DUAL;