Oracle SQL and PL/SQL function to convert proper IPv4 address (i.e., 32-bit integer) into the standard, "dotted" format

long2ip.sql

-- We have a table (ip_log) of proper IPv4 addresses (ip)
select bitand(ip / 16777216, 255) || '.' || bitand(ip / 65536, 255) || '.' || bitand(ip / 256, 255) || '.' || bitand(ip, 255) ip
from   ip_log;

-- ...or a function to do the same:
create or replace function long2ip(ip in number)
return varchar2 deterministic
as
begin
  return bitand(ip / 16777216, 255) || '.' ||
         bitand(ip / 65536, 255)    || '.' ||
         bitand(ip / 256, 255)      || '.' ||
         bitand(ip, 255);
end long2ip;
/

-- Now we can do:
select long2ip(ip) ip from ip_log;
select long2ip(167772161) ip from dual; -- 10.0.0.1