oracle 排 序

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='对应方式';