oracle 字符串和数字组合按数字排序

jiues

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