--------按笔画(第一顺序)、部首(第二顺序)排序
SELECT * FROM TestHZ
ORDER BY NLSSORT(SortName,'NLS_SORT = SCHINESE_STROKE_M')
--------按部首(第一顺序)、拼音(第二顺序)排序
SELECT * FROM TestHZ
ORDER BY NLSSORT(SortName,'NLS_SORT = SCHINESE_RADICAL_M')
--------按拼音排序
SELECT * FROM TestHZ
ORDER BY NLSSORT(SortName,'NLS_SORT = SCHINESE_PINYIN_M')