oracle 汉字转拼音

来源:互联网 发布:中国自大 知乎 编辑:程序博客网 时间:2024/04/29 00:13

oracle 汉字转拼音:


insert into t_xzqh_css
  (bh0000, mc0000)
  select substr(bh0000, 0, 4),replace(ymc000,'市',''),LOWER(GETHZPY.GetHzFullPY(replace(replace(ymc000,'市',''),'自治州','')))
    from bm_bz_xzqh00 t
 where t.ymc000 not like '市%'
   and bh0000 like '____00'
   and bh0000 not like '__0000';