資源描述：
《oracle漢字轉(zhuǎn)拼音函數(shù)》由會員上傳分享，免費在線閱讀，更多相關(guān)內(nèi)容在教育資源-天天文庫。
1、第一種方法：（首字母/全拼）createorreplacetypespell_codeasobject(spellvarchar2(10),codenumber);createorreplacetypet_spellcodeistableofspell_code;--返回拼音與代碼的對應關(guān)系createorreplacefunctionf_getSpellcodereturnt_spellcodePipelinedisBegin?PIPERow(spell_code('a',-20319));??PIPERow(spell_code('ai',-20317));?????
2、?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_c
3、ode('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));????PIPERow(spell_code('bie',-19986
4、));?????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_code('can',-19763));?????PIPERow(
5、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',-19725));????PIPERow(spell_code('chan
6、g',-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));???PIPERow(spell_code('chou',-19479));????P
7、IPERow(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));????PIPERow(spell_code('chuo',-19263)
