Re: Informix vs. Oracle

Posted in 1997

Nils Myklebust — Wed, 20 Aug 1997 18:39:53 GMT — source: Informix-list mailing list archive (1991-1998)

ennis@ssax.com (Bill Ennis) wrote: :What about update cursors in Oracle? Oracle will lock EVERY row :associated with an update cursor when the cursor is opened! Informix :will lock the row when it fetches. In this case Infomrix is better :for transaction independency. Such behaviour would have been a total showstopper for us. Do you (or anyone else) know if Oracle have "hold" cursors (cursors that are keept open accross a transaction)? In case they do are all rows locked when the cursor is opened in this case as well? If that is the case what happen to these locks when a transaction is committed? The Informix solution in this area is very good. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org