ORA01779: cannot modify a column which maps to a non keypreserved table
ORA-01779: 无法修改与非键值保存表对应的列
表t1
id name
1 tt
1 ry
表t2
id department
1 10
1 20
select * from t1,t2 where t1.id=t2.id;
id name id department
1 tt 1 10
1 tt 1 20
1 ry 1 10
1 ry 1 20
我们发现结果集里的两次出现的1 20都是来自表t2上的同一行数据行1 20,重