case when和decode

select fieldname,newvalue,oldvalue from guEndorEndorTextDetail where ENDORNO = 'P131010128820210000074';

对newvalue和oldvalue做处理，当fieldName字段的值包含性别或证件类型的时候，把他对应的newvalue和oldvalue转换成中文。

select fieldname,case when fieldname like '%性别%' then decode(newvalue,'1','男','2','女',newvalue) 
                           when fieldname like '%证件类型%' then decode(newvalue,'01','居民身份证','02','护照','03','军人证','04','驾驶证','05','港澳台同保证','07','中国护照','99','其他',newvalue) 
                               else newvalue 
                             end as newvalue,
                 case when fieldname like '%性别%' then decode(oldvalue,'1','男','2','女',oldvalue) 
                           when fieldname like '%证件类型%' then decode(oldvalue,'01','居民身份证','02','护照','03','军人证','04','驾驶证','05','港澳台同保证','07','中国护照','99','其他',oldvalue) 
                               else oldvalue 
                             end as oldvalue from guEndorEndorTextDetail where ENDORNO = 'P131010128820210000074';