ããORACLEæ°æ®åºä¸ææåºè§å
ããoracle9iä¹åï¼ä¸ææ¯æç
§äºè¿å¶ç¼ç è¿è¡æåºçã
ããå¨oracle9iä¸æ°å¢äºæç
§æ¼é³ãé¨é¦ãç¬ç»æåºåè½ã设置NLS_SORTå¼
ããSCHINESE_RADICAL_M æç
§é¨é¦ï¼ç¬¬ä¸é¡ºåºï¼ãç¬åï¼ç¬¬äºé¡ºåºï¼æåº
ããSCHINESE_STROKE_M æç
§ç¬åï¼ç¬¬ä¸é¡ºåºï¼ãé¨é¦ï¼ç¬¬äºé¡ºåºï¼æåº
ããSCHINESE_PINYIN_M æç
§æ¼é³æåºï¼ç³»ç»çé»è®¤æåºæ¹å¼ä¸ºæ¼é³æåº
ããalter session set nls_sort=âschinese_pinyin_mâ;
ããselect * from dept order by nlssort(name,âNLS_SORT=SCHINESE_PINYIN_Mâ);
温馨提示:答案为网友推荐,仅供参考