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

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

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

2、17));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',-20242));PIPERow(spell_code('bao',-20230))

3、;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));PIPERow(spell_code('bie',-19986));PIPERow(spell_code('bin',-19982))

4、;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_code('can',-19763));PIPERow(spell_code('cang',-19756));PIPERow(spell_code('cao',-19751));PI

5、PERow(spell_code('ce',-19746));PIPERow(spell_code('ceng',-19741));PIPERow(spell_code('cha',-19739));PIPERow(spell_code('chai',-19728));PIPERow(spell_code('chan',-19725));PIPERow(spell_code('chang',-19715));PIPERow(spell_code('chao',-19540));PIPERow(spell_code('che',-19531))

6、;PIPERow(spell_code('chen',-19525));PIPERow(spell_code('cheng',-19515));PIPERow(spell_code('chi',-19500));PIPERow(spell_code('chong',-19484));PIPERow(spell_code('chou',-19479));PIPERow(spell_code('chu',-19467));PIPERow(spell_code('chuai',-19289));PIPERow(spell_code('chuan',

7、-19288));PIPERow(spell_code('chuang',-19281));PIPERow(spell_code('chui',-19275));PIPERow(spell_code('chun',-19270));PIPERow(spell_code('chuo',-19263));PIPERow(spell_code('ci',-19261));PIPERow(spell_code('cong',-19249));PIPERow(spell_code('cou',-19243));PIPERow(spell_code('c

8、u',-19242));PIPERow(spell_code('cuan',-19238));PIPERow(spell_code('cui',-19235));P