oracle case where 复杂sql语句

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

update hr_user u set u.is_approve=(case
when u.curr_org_id in
(select t.org_id
from hr_organization t
start with t.org_id = 10001263
connect by prior org_id = t.org_id_parent) then
'N'
ELSE
'Y'
END); update hr_user u set u.is_approve=(case
when u.curr_org_id in
(select t.org_id
from hr_organization t
start with t.org_id = 10001263
connect by prior org_id = t.org_id_parent) then
'N'
ELSE
'Y'
END) where u.EMP_NUM='';