Oracle case when 查询和更新(不积跬步,无以至千里)

查询

(case when c.material_type=0 then 0 
                when c.material_type=0 then 1 when c.material_type=2 then 5 else 0 end) as process_status

更新

UPDATE pur_pr_item_work SET process_status=
CASE WHEN MATERIAL_TYPE='1' THEN 1 WHEN MATERIAL_TYPE='2' THEN 5 END
WHERE PR_FORM_NO=10208