Oh and PS. Explain to him that updating the primary key column will throw database locks all over the place. And this will cost time. Tom Mercadante Oracle Certified Professional -----Original Message----- From: ryan_gaffuri@xxxxxxxxxxx [mailto:ryan_gaffuri@xxxxxxxxxxx] Sent: Tuesday, September 28, 2004 11:37 AM To: oracle-l@xxxxxxxxxxxxx Subject: looking for doc with diagrams on redo and undo for java developers Object Oriented programming is all about reuse so our java guys made a universal update statement that updates all columns in a table, even unchanged columns. I know its bad, but its a major re-write to change this. I was digging through the otn docs and some books and everything that leads me to this requires a significant amount of reading. Multiple chapters etc... anyone know a short article that explains undo and redo along with diagrams and why its bad to update unchanged columns that is easy for a non-oracle person to follow? checked the concepts doc, but they would probably have to read 50-70 pages to get the basic idea. -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l