比如:
这是存入数据库的数据
String [] str =
new String[]{"info1","info10","info2","info3","info4","info5-5","info6-4","info7-4"};
这是SQL语句
select * from talbe order by
to_number(translate(排序的字段, '0123456789' || 排序的字段, '0123456789')
比如:
这是存入数据库的数据
String [] str =
new String[]{"info1","info10","info2","info3","info4","info5-5","info6-4","info7-4"};
这是SQL语句
select * from talbe order by
to_number(translate(排序的字段, '0123456789' || 排序的字段, '0123456789')