oracle中判断写法

update SH_DISH_LEVEL_MODEL s set s.hotlevel=(
to_number(
(select
case
when sdlm.hotlevel is null
then 0
end asd
from SH_DISH_LEVEL_MODEL sdlm where sdlm.uuid='4028801541a572460141a58a6c93000e'
)) + 4
) where s.uuid='4028801541a572460141a58a6c93000e'

转载于:https://blog.51cto.com/zhangchi/1309147