'NLS_SORT=SCHINESE_RADICAL_M'); --按照拼音排序: select * from table order by nlssort(col,'NLS_SORT=SCHINESE_PINYIN_M'); --解决: 1班 2班 3班 select * from table order by to_number(regexp_substr(a.bjname,'[0-9]*[0-9]',1)); 4班...