update DEPT_BK B set DEPTNO = DEPTNO from DEPT A where A.DNAME = B.DNAME www.ipentec.comupdate DEPT_BK3 set LOC = 'test3' where DEPTNO = '10'; select * from DEPT_BK3 update DEPT_BK3 A set DEPTNO = (select B.DEPTNO from DEPT B where A.LOC =…