汉字转拼音pl/sql

汉字转拼音（首字母）pl/sq

CREATE OR REPLACE fuNCtion getpy( chnstr in char) return vaRCHar2 Is
pytable long;
no integer;
py varchar2 (200);
str varchar2(200);
pyi integer;
ch1 varchar2(2);
len integer;
begin
pytable:= 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'
||'aaaabbbbbbbbbbbbbbbbbbbbbbbbbbbb'
||'bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb'
||'bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb'
||'bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb'
||'bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb'
||'bbbbbbbbbbbbbbbbbbbbbbbbbbbbcccc'
||'cccccccccccccccccccccccccccccccc'
||'cccccccccccccccccccccccccccccccc'
||'cccccccccccccccccccccccccccccccc'
||'cccccccccccccccccccccccccccccccc'
||'cccccccccccccccccccccccccccccccc'
||'cccccccccccccccccccccccccccccccc'
||'cccccccccccccccccccccccccccccccc'
||'cccccddddddddddddddddddddddddddd'
||'dddddddddddddddddddddddddddddddd'
||'dddddddddddddddddddddddddddddddd'
||'dddddddddddddddddddddddddddddddd'
||'dddddddddddddddddddddddddddddddd'
||'dddddddddddddddddddddddddddddeee'
||'eeeeeeeeeeeeeeeeeeefffffffffffff'
||'ffffffffffffffffffffffffffffffff'
||'ffffffffffffffffffffffffffffffff'
||'ffffffffffffffffffffffffffffffff'
||'ffffffffffffffffgggggggggggggggg'
||'gggggggggggggggggggggggggggggggg'
||'gggggggggggggggggggggggggggggggg'
||'gggggggggggggggggggggggggggggggg'
||'gggggggggggggggggggggggggggggggg'
||'ggggggggggghhhhhhhhhhhhhhhhhhhhh'
||'hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh'
||'hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh'
||'hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh'
||'hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh'
||'hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh'
||'jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj'
||'jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj'
||'jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj'
||'jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj'
||'jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj'
||'jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj'
||'jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj