oracle 中文資料排序的問題 感謝Lawrence 分享

Lawrence.Lin says: (下午3:09:55)
中文排序: 範例
依筆劃
select region from region_cod where city='台北市' and district='中山區' order by nlssort(region,'NLS_SORT=TCHINESE_STROKE_M');
Lawrence.Lin says: (下午3:10:05)
依部首
select region from region_cod where city='台北市' and district='中山區' order by nlssort(region,'NLS_SORT=TCHINESE_RADICAL_M');