1、nlssort函数的作用是对字段排序,字符串类型的
2、按拼音排序:sele罕铞泱殳ct * from MEMBER t order by NLSSORT(t.b,'NLS_SORT = SCHINESE_PINYIN_M')
3、按笔画排序:select * from MEMBER t order by NLSSORT(t.b,'NLS_SORT = SCHINESE_STROKE_M')
4、按部首排序:sele罕铞泱殳ct * from MEMBER t order by NLSSORT(t.b,'NLS_SORT = SCHINESE_RADICAL_M')