Oracle ~ case when then的使用

先上一段 代码 

select c.containername,pb.productname || '('||p.productrevision||')' as product
 ,pt.producttypename,
ms.sw_location2,ms.sw_lot,ms.sw_materialstockname,ms.sw_stockqty,
ms.sw_loadedqty,ms.sw_totalqty,u.uomname,
r.resourcename || r.description as 设备,rt.resourcetypename,ms.sw_carriername,
case ms.sw_instocktype when '0' then '半成品'
when  '1' then '原材料'
when  '2' then '在制品'
when  '3' then '成品' end as sw_instocktype,  
s.shiftname,ms.sw_instockdate
from sw_materialstock ms
left join container c on c.containerid = ms.sw_containerid
left join product p  on p.productid = ms.sw_productid
left join productbase pb on pb.productbaseid = p.productbaseid
left join producttype pt on pt.producttypeid = p.producttypeid
left join resourcedef r on r.resourceid = ms.sw_resourceid
left join shift s on s.shiftid = ms.sw_shiftid
left join uom u  on u.uomid = ms.sw_uomid
left join resourcetype rt on rt.resourcetypeid = r.resourcetypeid
where 1 = 1 

 比方说，上图中sw_instockType 存的是枚举类型，在业务中0代表半成品，那么then的后面就跟你想要在展示的内容，最后以end结束，当然建议另起名 as XXX ，比如上图中的 as sw_nstockType