Oracle/MySQL °ü·Ã °Ô½ÃÆÇ |
---|
2014/04/21(22:19) from 59.1.178.174 | |
ÀÛ¼ºÀÚ : ÁÖÀÎÀå | Á¶È¸¼ö : 3634 , ÁÙ¼ö : 15 |
[Oracle] INET_ATON ÇÔ¼ö (20¹è ºü¸§) |
---|
create or replace function inet_aton( p_str in varchar2 ) return number as l_dot1 number := instr( p_str, '.',1,1 ); l_dot2 number := instr( p_str, '.',1,2 ); l_dot3 number := instr( p_str, '.',1,3 ); begin return to_number(substr(p_str,1,l_dot1-1))*power(256,3)+ to_number(substr(p_str,l_dot1+1, l_dot2-l_dot1-1))*power(256,2)+ to_number(substr(p_str,l_dot2+1,l_dot3-l_dot2-1))*256+ to_number(substr(p_str,l_dot3+1)); end; |