可以参考一下https://blog.csdn.net/weixin_44158741/article/details/110469648

CREATE OR REPLACE FUNCTION inet_aton( f_address IN varchar2 ) RETURN number 
AS 
    o_address_number number;
BEGIN

	SELECT
      to_number(regexp_replace(f_address, '([0-9]{1,3})\.([0-9]{1,3})\.([0-9]{1,3})\.([0-9]{1,3})', '\1')) * 16777216 +
      to_number(regexp_replace(f_address, '([0-9]{1,3})\.([0-9]{1,3})\.([0-9]{1,3})\.([0-9]{1,3})', '\2')) * 65536 +
      to_number(regexp_replace(f_address, '([0-9]{1,3})\.([0-9]{1,3})\.([0-9]{1,3})\.([0-9]{1,3})', '\3')) * 256 +
      to_number(regexp_replace(f_address, '([0-9]{1,3})\.([0-9]{1,3})\.([0-9]{1,3})\.([0-9]{1,3})', '\4')) INTO o_address_number;
		
	RETURN o_address_number;
	
END inet_aton;


select inet_aton('10.16.25.0') from dual;