打印本文 打印本文 关闭窗口 关闭窗口
【原创】oracle数据库应用中实现汉字“同音”查询
作者:武汉SEO闵涛  文章来源:敏韬网  点击数4279  更新时间:2009/4/22 22:03:45  文章录入:mintao  责任编辑:mintao
'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''gao'''',''''47325'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''ge'''',''''47335'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''gei'''',''''47352'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''gen'''',''''47353'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''geng'''',''''47355'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''gong'''',''''47524'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''gou'''',''''47539'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''gu'''',''''47548'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''gua'''',''''47566'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''guai'''',''''47572'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''guan'''',''''47575'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''guang'''',''''47586'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''gui'''',''''47589'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''gun'''',''''47605'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''guo'''',''''47608'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''ha'''',''''47614'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''hai'''',''''47777'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''han'''',''''47784'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''hang'''',''''47803'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''hao'''',''''47806'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''he'''',''''47815'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''hei'''',''''47833'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''hen'''',''''47835'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''heng'''',''''47839'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''hong'''',''''47844'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''hou'''',''''47853'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''hu'''',''''47860'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''hua'''',''''48040'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''huai'''',''''48049'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''huan'''',''''48054'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''huang'''',''''48068'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''hui'''',''''48082'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''hun'''',''''48103'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''huo'''',''''48109'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''ji'''',''''48119'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''jia'''',''''48334'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''jian'''',''''48351'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''jiang'''',''''48553'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''jiao'''',''''48566'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''jie'''',''''48594'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''jin'''',''''48621'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''jing'''',''''48803'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''jiong'''',''''48828'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''jiu'''',''''48830'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''ju'''',''''48847'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''juan'''',''''48872'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''jue'''',''''48879'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''jun'''',''''48889'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''ka'''',''''49062'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''kai'''',''''49066'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''kan'''',''''49071'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''kang'''',''''49077'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''kao'''',''''49084'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''ke'''',''''49088'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''ken'''',''''49103'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''keng'''',''''49107'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''kong'''',''''49109'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''kou'''',''''49113'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''ku'''',''''49117'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''kua'''',''''49124'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''kuai'''',''''49129'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''kuan'''',''''49133'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''kuang'''',''''49135'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''kui'''',''''49143'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''kun'''',''''49316'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''kuo'''',''''49320'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''la'''',''''49324'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''lai'''',''''49331'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''lan'''',''''49334'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''lang'''',''''49349'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''lao'''',''''49356'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''le'''',''''49365'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''lei'''',''''49367'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''leng'''',''''49378'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''li'''',''''49381'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''lia'''',''''49577'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''lian'''',''''49578'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''liang'''',''''49592'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''liao'''',''''49603'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''lie'''',''''49616'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''lin'''',''''49621'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''ling'''',''''49633'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''liu'''',''''49647'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''long'''',''''49658'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''lou'''',''''49829'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''lu'''',''''49835'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''lv'''',''''49855'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''luan'''',''''49869'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''lue'''',''''49875'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''lun'''',''''49877'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''luo'''',''''49884'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''ma'''',''''49896'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''mai'''',''''49905'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''man'''',''''49911'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''mang'''',''''50082'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''mao'''',''''50088'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''me'''',''''50100'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''mei'''',''''50101'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''men'''',''''50117'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''meng'''',''''50120'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''mi'''',''''50128'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''mian'''',''''50142'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''miao'''',''''50151'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''mie'''',''''50159'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''min'''',''''50161'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''ming'''',''''50167'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''miu'''',''''50173'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''mo'''',''''50174'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''mou'''',''''50353'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''mu'''',''''50356'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''na'''',''''50371'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''nai'''',''''50378'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''nan'''',''''50383'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''nang'''',''''50386'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''nao'''',''''50387'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''ne'''',''''50392'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''nei'''',''''50393'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''nen'''',''''50395'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''neng'''',''''50396'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''ni'''',''''50397'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''nian'''',''''50408'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''niang'''',''''50415'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''niao'''',''''50417'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''nie'''',''''50419'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''nin'''',''''50426'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''ning'''',''''50427'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''niu'''',''''50595'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''nong'''',''''50599'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''nu'''',''''50603'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''nv'''',''''50606'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''nuan'''',''''50607'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''nue'''',''''50608'''')
/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(''''nuo'''',''''5061

上一页  [1] [2] [3] [4] [5] [6]  下一页

打印本文 打印本文 关闭窗口 关闭窗口