oracle多个值进行替换,（求高人指点指点）oracle高手过招：使用case when then替换字段数据，比实际的多了几百条数据 求解,该如何解决...

SQL codecreate or replace procedure proc4(qihao in varchar2)

is

sr_id number;

cp_id varchar2(50);

kh_id varchar2(50);

gs_id varchar2(50);

type cur is ref cursor ;

cur_cpkh cur ;

begin

open cur_cpkh for select sum(sr) ,c.col_1_1_214_14 ,

case s.www06

when 12 then 'KH09010101'

when 13 then'KH09010102'

when 14 then 'KH09010103'

when 16 then 'KH09010201'

when 17 then 'KH09010202'

when 18 then 'KH09010203'

when 20 then 'KH09010301'

when 21 then 'KH09010302'

when 22 then 'KH09010303'

when 23 then 'KH09010304'

when 25 then 'KH09010401'

when 26 then 'KH09010402'

when 27 then 'KH09010403'

when 29 then 'KH09010501'

when 30 then &#