Oracle Kanji Pinyin (get full spell/pinyin initials/Pinyin intercept, etc.)

Oracle Kanji Pinyin (get full spell/pinyin initials/Pinyin intercept, etc.)

The effect is as follows: Oracle character Set GBK no problem, UTF-8 needs to be modified

SQL code
--oracle Kanji to Pinyin package
--1. Get full spell
SELECT gethzpy. Gethzfullpy (' kanji ') from DUAL;
Results: Hanzi


--2. Pinyin First Letter
SELECT gethzpy. Gethzpycap (' kanji ') from DUAL;
Result: HZ


--3. Pinyin interception, etc.
SELECT gethzpy. Gethzpycapsubstr (' kanji ', 0, 1) from DUAL;

Results: H

Oracle Kanji Pinyin Package_ get full spell-Pinyin first letter _ Pinyin intercept and so on. zip
Function 3 Use this package as needed
Http://up.2cto.com/2012/0926/20120926102526632.zip

Note: The contents of the essay are from the online data collation, for reference only.

Oracle Kanji Pinyin (get full spell/pinyin initials/Pinyin intercept, etc.)