mrong
asked on
SQL Update error
Hello,
I tried to update a field(non-null field) in oracle table but got the following error. Anyone know the reason and suggestions?
ORA-01779: cannot modify a column which maps to a non key-preserved table
Thanks in advance.
I tried to update a field(non-null field) in oracle table but got the following error. Anyone know the reason and suggestions?
ORA-01779: cannot modify a column which maps to a non key-preserved table
Thanks in advance.
ASKER
How to tell if it is a table or a view? thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Check out that error code:
http://ora-01779.ora-code.com/