nlssort方法/函数 oracle

1、 nlssort函数的作用是对字段排序，字符串类型的

2、按拼音排序：

select * 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、按部首排序：

select * from MEMBER t order by NLSSORT(t.b,'NLS_SORT = SCHINESE_RADICAL_M')