Oracle按字段的笔画,部首,拼音的排序方法
摘要:1)按笔画排序 select*fromTableorderbynlssort(columnName,'NLS_SORT=SCHINESE_STROKE_M')2)按部首排序 select*fromTableorderbynlssort(columnName,'NLS_SORT=SCHINESE_RADICAL_M')3)按拼音排序 select*fromTableorderbynlssort(columnName,'NLS_SORT=SCHINESE_PINYIN_M');
阅读全文
posted @
2013-11-05 11:59
WeiLight
阅读(318)
推荐(0)