这个和 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
责任编辑：小草
您现在的位置： 