oracle汉字转拼音(获得全拼/拼音首字母/拼音截取等)
1.获得全拼
SELECT GETHZPY.GETHZFULLPY('拼音') FROM DUAL;
结果 : PinYin
2.拼音首字母
SELECT GETHZPY.GETHZPYCAP('拼音') FROM DUAL;
结果 : PY
3.拼音截取等
SELECT GETHZPY.GETHZPYCAPSUBSTR('拼音', 0, 1) FROM DUAL;
结果 : P
4、全部汉字判断
select case when trim(pi.patientname)=to_multi_byte(trim(pi.patientname)) then '全是汉字'||' '||pi.patientname else pi.patientname end
from patientinformation pi
where pi.barcode='37296053'
;
5、名 姓
select INITCAP(GETHZPY.GETHZFULLPY(substr('姓测试',2))) ||' '||INITCAP(GETHZPY.GETHZFULLPY(substr('姓测试',1,1))) from dual;