oracle9i中新增了按照拼音、部首、笔画排序功能
用法示例: 拼音
SELECT * FROM TEAM ORDER BY NLSSORT(排序字段,'NLS_SORT = SCHINESE_PINYIN_M')
笔划
SELECT * FROM TEAM ORDER BY NLSSORT(排序字段,'NLS_SORT = SCHINESE_STROKE_M')
部首
SELECT * FROM TEAM ORDER BY NLSSORT(排序字段,'NLS_SORT = SCHINESE_RADICAL_M')
如果需要排序影响整个会话,可以作如下设置:
ALTER SESSION SET NLS_SORT='对应方式';