ORACLE根据中文拼音首字母排序、取得中文拼音首字母函数 电脑资料

ORACLE根据中文拼音首字母排序、取得中文拼音首字母函数 电脑资料 根据中文拼音首字母排序、取得中文拼音首字母函数 介绍根据中文的首字母、笔画、部首排序函数【NLSSORT】： 1）、首字母 SELECT * FROM T_TABLE ORDER BY NLSSORT(NAME, NLS_SORT=SCHINESE_PINYIN_M); 2）、笔画 SELECT * FROM T_TABLE ORDER BY NLSSORT(NAME, NLS_SORT=SCHINESE_STROKE_M); 3）、部首 SELECT * FROM T_TABLE ORDER BY NLSSORT(NAME, NLS_SORT=SCHINESE_RADICAL_M); 列表一行汉字 WITH A AS (SELECT 获取汉字拼音首字母 W FROM DUAL) SELECT SUBSTR(W, ROWNUM, 1) FROM A CONNECT BY ROWNUM = (SELECT LENGTH(W) FROM A); 返回结果 获 取 汉 字 拼 音 首 字 母 用汉字字符集对这个列表进行排序 WITH A AS - (SELECT 获取汉字拼音首字母 W FROM DUAL) SELECT SUBSTR(W, ROWNUM, 1) FROM A CONNECT BY ROWNUM = (SELECT LENGTH(W) FROM A) ORDER BY NLSSORT(SUBSTR(W, ROWNUM, 1), NLS_SORT=SCHINESE_PINYIN_M); 返回结果 汉 获 母 拼 取 首 音 字 字 那么根据这个原理，上面输入一个拼音A打头的字澳，后面输入一个B大头的字吧，找到每个音节的起止的汉字是哪个 WITH A AS ( SELECT ROWNUM RN, CHR(ROWNUM) C FROM DUAL CONNECT BY LEVEL 32768 - AND NLSSORT(C, NLS_SORT=SCHINESE_PINYIN_M) NLSSORT(澳, NLS_SORT=SCHINESE_PINYIN_M) AND NLSSORT(C, NLS_SORT=SCHINESE_PINYIN_M) = F_NLSSORT( 吖 ) AND V_PARE = F_NLSSORT(八 ) AND V_PARE = F_NLSSORT(嚓 ) AND V_PARE = F_NLSSORT(咑 ) AND V_PARE = F_NLSSORT(妸 ) AND V_PARE = F_NLSSORT(发 ) AND V_PARE = F_NLSSORT(旮 ) AND V_PARE = F_NLSSORT(妎 ) AND V_PARE = F_NLSSORT(丌 ) AND V_PARE = F_NLSSORT(咔 ) AND V_PARE = F_NLSSORT(垃 ) AND V_PARE = F_NLSSORT(嘸 ) AND V_PARE = F_NLSSORT(拏 ) AND V_PARE = F_NLSSORT(筽 ) AND V_PARE = F_NLSSORT(妑 ) AND V_PARE = F_NLSSORT(七 ) AND V_PARE = F_NLSSORT(亽 ) AND V_PARE = F_NLSSORT(仨 ) AND V_PARE = F_NLSSORT(侤 ) AND V_PARE = F_NLSSORT(屲 ) AND V_PARE = F_NLSSORT(夕 ) AND V_PARE = F_NLSSORT(丫 ) AND V_PARE = F_NLSSORT(帀 ) AND V_PARE = F_NLSSORT(咗 ) THEN V_RETURN := V_RETURN | z; END IF; END LOOP; RETURN V_RETU