oralce中文排序

 一、中文排序  
   1. //按照笔划排序

   2. select * from dept order by nlssort(name,'NLS_SORT=SCHINESE_STROKE_M');

   3. //按照部首排序

   4. select * from dept order by nlssort(name,'NLS_SORT=SCHINESE_RADICAL_M');

   5. //按照拼音排序，此为系统的默认排序方式

   6. select * from dept order by nlssort(name,'NLS_SORT=SCHINESE_PINYIN_M');