oracle 字符串和数字组合按数字排序
?
oracle 字符串和数字组合按数字排序
?
比如：
String [] str = new String[]{"info1","info10","info2","info3","info4","info5","info6","info7"};
?
? ?按自增排序 1 到10；
?
select ?* from talbe order by?to_number(translate(排序的字段,?'0123456789'?||?排序的字段,?'0123456789')
?