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
ORA01779: cannot modify a column which maps to a non keypreserved table
表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