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'
页:
[1]