nlssort方法/函数 oracle

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')