oracle的update和delete语句中可以用left join语句吗

Question

如题所述

Answer 1

可以
例如：

1 update:
update dept
set dname = 'ORACLE'
where deptno in
(select a.deptno from emp a left join dept b on a.deptno = b.deptno);

2 delete:
delete dept
where deptno in
(select a.deptno from emp a left join dept b on a.deptno = b.deptno);