春哥也编程

摘要： -- 按字符方式排序 select * from perexl order by perexl.xx -- 按字符对应的数字方式排序 select * from perexl order by to_number(perexl.xx) -- 按拼音排序 (系统默认) select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_PINYIN_M'); -- 按部首排序 select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_STROK 阅读全文