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

oracle複雜sql語句   oracle動態交叉表，oracle預存程序分頁

oracle case where 複雜sql語句