select t.*,to_number(regexp_substr(t.st_order,'[0-9]*/.*')) as a from t_sys_module t order by to_number(regexp_substr(t.st_order,'[0-9]*/.*'))
1 8121367a-0078-4e2d-b5bc-035ae3e8209f 护照签证 1.2 1
2 7c0f62eb-67d7-4665-86f5-de673f5fd127 出国考察 出国 2 2
3 b41cacab-3b72-4ea2-a030-1f6be58a4361 培训计划 11.11 11
4 8121367a-0078-4e2d-b5bc-035ae3e8209g 111 11.2 11
regexp_like()
regexp_instr()
regexp_substr()
regexp_replace()