oracle case where 复杂sql语句
时间：2021-07-01 10:21:17
帮助过：3人阅读
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‘;
oracle复杂sql语句 oracle动态交叉表，oracle存储过程分页
oracle case where 复杂sql语句
标签：
