update records in one table based on values in another table

SQL> -- update records in one table based on values in another table. SQL> SQL> UPDATE emp 2 SET ename = ( SELECT dname 3 FROM dept 4 WHERE emp.deptno = dept.deptno) 5 WHERE EXISTS 6 ( SELECT dname 7 FROM dept 8 WHERE emp.deptno = dept.deptno); SQL>