Oracle: Update .... Join

这个和 SqlServer的UPDATE .. FROM 语法相似

 

 

比如：

update employee_bonus
   set bonus = 0
 from employee_bonus b
 inner join employees e on b.employee_id = e.employee_id
 where e.bonus_eligible = 'N'

 

 

 

ORACLE里面需要这样才能完成上面的功能

 

 

 

update ( select bonus
           from employee_bonus b
          inner join employees e on b.employee_id = e.employee_id
          where e.bonus_eligible = 'N' ) t
 set t.bonus = 0