Nlssort函数

102 阅读1分钟

数据库有一个国家表,现在需要查询出所有国家的数据,并且按照首字符进行排序。那么就可以使用nlssort函数:

按照拼音排序

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

按照笔画排序

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

按照部首排序

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