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