解决oracle根据字段类型为字符串(中间包含数字)按顺序排序问题
select p.attribute1_,p.attribute2_,p.* from app_pay_payment p order by p.attribute1_,regexp_substr(p.attribute2_,'[^0-9]+'),to_number(regexp_substr(p.attribute2_,'[0-9]+'))
