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';