oracle 批量update进行判断

使用oracle进行批量update更新数据的时候，可以在更新前进行判断，根据条件进行批量更新
update tables_name t
set t.value1 = case
when t.value1 = '33020' then
'330200'
when t.value1 = '33021' then
'330210'
when t.value1 = '33022' then
'330221'
end
where t.value1 in ('33020', '33021', '33022');