RishOraDev's Oracle Blogs

Oracle 23ai allows directs joins in update and delete statements. Let us understand how this works. Lets say we have two tables DEPARTMENT1. SQL> SELECT * FROM department_1; DEPTNO DNAME LOC_________ _____________ ___________ 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON And DEPARTMENT_2. SQL> SELECT * FROM department_2; DEPTNO DNAME LOC_________ __________________________ ___________ 10 Accounting-10(New