oracle case where 复杂sql语句

最新推荐文章于 2022-08-11 15:38:41 发布

weixin_30797027

最新推荐文章于 2022-08-11 15:38:41 发布

阅读量200

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/xunianchong/p/4701384.html

版权

         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='066001';