how to get IP address through SQL

how to get IP address through SQL

Select Sys_Context('USERENV', 'IP_ADDRESS') From Dual;

select UTL_INADDR.get_host_address('host name') from dual where host_name is
select host_name from v$instance