oracle中,利用nlssort函数,对汉字排序,按拼音顺序排序
order by nlssort(t1.NAME, 'NLS_SORT=SCHINESE_PINYIN_M')
order by nlssort(t1.NAME, 'NLS_SORT=SCHINESE_PINYIN_M')