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';