RE: looking for doc with diagrams on redo and undo for java devel opers

  • From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
  • To: "'ryan_gaffuri@xxxxxxxxxxx'" <ryan_gaffuri@xxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 28 Sep 2004 11:47:01 -0400

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

Other related posts: