Square DBA – Oracle DBA Talk

Today we needed a was to performa DNS query from inside an Oracle database.  Low and behold Oracle already has a function for that.  The utility is called UTL_INADDR. Beautiful little utility. Here are the examples I sent to the people that needed them.

SELECT utl_inaddr.get_host_name(’68.180.206.184′) from dual;
SELECT utl_inaddr.get_host_address(‘yahoo.com’) FROM dual;