数据库有一个国家表,现在需要查询出所有国家的数据,并且按照首字符进行排序。那么就可以使用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')