Oracle - Update statement with inner join - Stack Overflow

Oracle - Update statement with inner join - Stack Overflow

瀏覽:837
日期:2026-04-19
Oracle does not support joins in the UPDATE statements. Use this: MERGE INTO table1 USING ( SELECT t1.rowid AS rid, t2.code FROM table1 t1 JOIN table2 t2 ON table1.value = table2.DESC WHERE table1.UPDATETYPE ......看更多