Friday, April 4, 2014

oracle snippet for sorting by ip address


select n from t1 order by regexp_replace(regexp_replace(n, '(\d+)', '00\1'), '0*(\d{3})', '\1');

No comments: