经常遇到汉字排序问题,比如省份按序排列之后方便查看:
select * from tbl_province_inf
order by nlssort(PROVINCENAME,'NLS_SORT=SCHINESE_PINYIN_M')
经常遇到汉字排序问题,比如省份按序排列之后方便查看:
select * from tbl_province_inf
order by nlssort(PROVINCENAME,'NLS_SORT=SCHINESE_PINYIN_M')