select utl_inaddr.get_host_name('127.0.0.1') from dual
/

pause

select utl_inaddr.get_host_name('**'||(select banner from v$version where rownum=1)||'**') from dual
/