这个和 SqlServer的UPDATE .. FROM 语法相似比如： update employee_bonusset bonus = 0 from employee_bonus b inner join employees e on b.employee_id = e.em......
这个和 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
|
