oracle case when

参考 https://blog.csdn.net/yangzjchn/article/details/81019449

 

select case
when t.content = '1' then
'满意'
when t.content = '2' then
'一般'
else
'不满意'
end satis
from satisfaction t;