Orcal 数字与字母 排序

1.有规律的数据排序

select * from zgpf02  order by  to_number(substr(sn,10)) asc

2.无规律的数据排序
order by to_number(regexp_substr(排序字段,’[0-9]*[0-9]’,1))

select * from sfc_form_list
     where shift = #{shift} and ydate = #{yDate}
     order by to_number(regexp_substr(lineid,'[0-9]*[0-9]',1))