UPDATE with inline view - ORA-01779:cannot modify a column which maps to a
Hello....
With the following SQL, I get the ORA-01779 mentioned in the Subject Line:
update
(select a.old_c1
,a.old_c2
,a.old_c3
,b.old_c1
,b.old_c2
,b.old_c3
from table1 a, table2 b
where a.id = b.id)
set a.old_c1 = b.old_c1
,a.old_c2 = b.old_c2
,a.old_c3 = b.old_c3;
Any help or explanation would be helpful. Thank you.