Hi~ Summers!!

[함수] Netmask bit 계산 (netmask → bit) 본문

개발/DB

[함수] Netmask bit 계산 (netmask → bit)

eNaNII 2007. 3. 13. 17:58

CREATE OR REPLACE FUNCTION to_maskfromnumber(number_in IN number)
RETURN varchar2
IS
netmask varchar2(17);

BEGIN
netmask := to_ipfromnumber(4294967295-power(2,32-number_in)+1);
RETURN netmask;
END;
/

Comments