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')