Oracle case when

select
CASE t.receipt_kind
WHEN ‘1’ THEN ‘Accomodation’
WHEN ‘2’ THEN ‘Restaurant’
WHEN ‘3’ THEN ‘Shop’
WHEN ‘4’ THEN ‘Others’
END Sector,
from t_rmm_receipt t
where 1=1
case到end之间相当于一个具体的值，可以做运算，取别名，嵌套case 。