效果图
sql语句
ORDER BY to_number((substr(t1.PRO_SEQ,instr(t1.PRO_SEQ,'_')+1))) ASC,to_number((substr(t1.PRO_SEQ,1,instr(t1.PRO_SEQ,'_')-1))) ASC
ORDER BY to_number((substr(t1.PRO_SEQ,instr(t1.PRO_SEQ,'_')+1))) ASC,to_number((substr(t1.PRO_SEQ,1,instr(t1.PRO_SEQ,'_')-1))) ASC