Oracle的nlssort函数
-
nlssort函数的作用是对字段排序，字符串类型的
-
1.按拼音排序：
select * from MEMBER t order by NLSSORT(t.b,'NLS_SORT = SCHINESE_PINYIN_M')
-
-
-
-
-
2.按笔画排序：
select * from MEMBER t order by NLSSORT(t.b,'NLS_SORT = SCHINESE_STROKE_M')
-
-
-
-
-
-
3.按部首排序：
select * from MEMBER t order by NLSSORT(t.b,'NLS_SORT = SCHINESE_RADICAL_M')
-