将汉字转为全拼或返回拼音首字母

《将汉字转为全拼或返回拼音首字母》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、createorreplacetypespell_codeasobject(spellvarchar2(10),codenumber);createorreplacetypet_spellcodeistableofspell_code;--·µ»ØÆ´ÒôÓë´úÂëµÄ¶ÔÓ¦¹Øϵcreateorreplacefunctionf_getSpellcodereturnt_spellcodePipelinedisBeginPIPERow(spell_code('a',-20319));PIPERo

2、w(spell_code('ai',-20317));PIPERow(spell_code('an',-20304));PIPERow(spell_code('ang',-20295));PIPERow(spell_code('ao',-20292));PIPERow(spell_code('ba',-20283));PIPERow(spell_code('bai',-20265));PIPERow(spell_code('ban',-20257));PIPERow(spell_code('bang

3、',-20242));PIPERow(spell_code('bao',-20230));PIPERow(spell_code('bei',-20051));PIPERow(spell_code('ben',-20036));PIPERow(spell_code('beng',-20032));PIPERow(spell_code('bi',-20026));PIPERow(spell_code('bian',-20002));PIPERow(spell_code('biao',-19990));P

4、IPERow(spell_code('bie',-19986));PIPERow(spell_code('bin',-19982));PIPERow(spell_code('bing',-19976));PIPERow(spell_code('bo',-19805));PIPERow(spell_code('bu',-19784));PIPERow(spell_code('ca',-19775));PIPERow(spell_code('cai',-19774));PIPERow(spell_cod

5、e('can',-19763));PIPERow(spell_code('cang',-19756));PIPERow(spell_code('cao',-19751));PIPERow(spell_code('ce',-19746));PIPERow(spell_code('ceng',-19741));PIPERow(spell_code('cha',-19739));PIPERow(spell_code('chai',-19728));PIPERow(spell_code('chan',-19

6、725));PIPERow(spell_code('chang',-19715));PIPERow(spell_code('chao',-19540));PIPERow(spell_code('che',-19531));PIPERow(spell_code('chen',-19525));PIPERow(spell_code('cheng',-19515));PIPERow(spell_code('chi',-19500));PIPERow(spell_code('chong',-19484));

7、PIPERow(spell_code('chou',-19479));PIPERow(spell_code('chu',-19467));PIPERow(spell_code('chuai',-19289));PIPERow(spell_code('chuan',-19288));PIPERow(spell_code('chuang',-19281));PIPERow(spell_code('chui',-19275));PIPERow(spell_code('chun',-19270));PIPE

8、Row(spell_code('chuo',-19263));PIPERow(spell_code('ci',-19261));PIPERow(spell_code('cong',-19249));PIPERow(spell_code('cou',-19243));PIPERow(spell_code('cu',-19242));PIPERow(spell_code('cuan',-19238));PIPERow(spell_code('cui',-19235));P