1、用MERGE的方式更新
例:将部门表中部门名称更新至职工表的deptna;
merge into emp e
using (select d.deptno, d.deptna from dept d) d
on (e.deptno = d.deptno) --注意这里要加()
when matched then
update set emp.deptna = d.deptna
1、用MERGE的方式更新
例:将部门表中部门名称更新至职工表的deptna;
merge into emp e
using (select d.deptno, d.deptna from dept d) d
on (e.deptno = d.deptno) --注意这里要加()
when matched then
update set emp.deptna = d.deptna