Oracle/MySQL °ü·Ã °Ô½ÃÆÇ |
---|
2014/04/21(22:19) from 59.1.178.174 | |
ÀÛ¼ºÀÚ : ÁÖÀÎÀå | Á¶È¸¼ö : 2971 , ÁÙ¼ö : 11 |
Re: [Oracle] INET_ATON ÇÔ¼ö (20¹è ´À¸²) |
---|
create or replace function inet_aton2( p_str in varchar2 ) return number as ret number; begin select xmlquery(('(((' || replace(p_str, '.', ')*256+')) returning content).getnumberval() into ret from dual; return ret; end inet_aton2; |