Oralce update 使用case when根据情况更新

update table
set
djyzmdm=null,
djyzmsj=null,
DLCS= case when DLCS is null then 1 else DLCS+1 end
where djyzmsj=‘xxx’

2、
update table
set
datetime = 1434567890,
status = case id when 12 Then 1 when 13 Then 2 end
where id in (12,13,14)

update table
set
datetime = 1434567890,
status = case when id =12 Then 1 when id=13 Then 2 end
where id in (12,13,14)