select * from LSK_SBCAJ t order by to_number(REGEXP_SUBSTR(xnum,'[0-9]+')) desc;
oracle按照某一字段里的数字排序
最新推荐文章于 2023-01-05 11:32:30 发布
select * from LSK_SBCAJ t order by to_number(REGEXP_SUBSTR(xnum,'[0-9]+')) desc;