您的位置: 首页 > 文章 > Oracle的nlssort函数 Oracle的nlssort函数 分类: 文章 • 2024-06-09 23:42:46 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')