oracle复杂sql语句 oracle动态交叉表，oracle存储过程分页
oracle case where 复杂sql语句
标签：
oracle case where 复杂sql语句
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=‘066001‘;