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))