How to UPDATE
in Oracle records without using a IN
clause to change bulk data?
This way:
UPDATE TABELA1 SET DADO = DADO
FROM TABELA2
WHERE TABELA1.CODIGO = TABELA2.CODIGO;
Currently it forces me to report a IN
clause:
UPDATE TABELA1 SET DADO = DADO
WHERE CODIGO IN (SELECT CODIGO FROM TABELA2);