用merge 更新emp表部门为 test 的数据
MERGE INTO emp a
USING (select dept.dname,emp_bak.* from dept,emp_bak where dept.dname='TEST' and dept.deptno=emp_bak.deptno) b
ON (a.empno=b.empno)
WHEN MATCHED THEN
UPDATE SET
a.deptno=b.deptno,
a.ename=b.ename,
a.job=b.job,
a.hiredate=b.hiredate,
a.mgr=b.mgr,
a.comm=b.comm,
a.sal=b.sal
WHEN NOT MATCHED THEN
insert(
a.deptno,
a.empno,
a.ename,
a.job,
a.hiredate,
a.mgr,
a.comm,
a.sal)
values(
b.deptno,
b.empno,
b.ename,
b.job,
b.hiredate,
b.mgr,
b.comm,
b.sal );
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25538895/viewspace-706893/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25538895/viewspace-706893/