Oracle 按汉字拼音排序

2019-05-25 / SQL / KOGU

按拼音排序：

SELECT * from STUDENT ORDER BY NLSSORT(NAME, 'NLS_SORT=SCHINESE_PINYIN_M')

按部首顺序

SELECT * from STUDENT ORDER BY NLSSORT(NAME, 'NLS_SORT=SCHINESE_RADICAL_M')

按笔画顺序

SELECT * from STUDENT ORDER BY NLSSORT(NAME, 'NLS_SORT=SCHINESE_STROKE_M')