Re: Article about supposed "murky" future for Oracle

From: rkusenet <rkusenet_at_sympatico.ca>
Date: Tue, 30 Mar 2004 14:42:46 -0500
Message-ID: <c4cifo$2h5tbc$1@ID-75254.news.uni-berlin.de>

"Thomas Kyte" <thomas.kyte_at_oracle.com> wrote

> Well, I didn't prove that really -- the point I made on page 35 was
> that

ha ha. this is getting better. So what Daniel Morgan has been doing is blindly believing oracle marketing hype. Not very smart of him.

> "in practically every other database, if you wanted to get a
> 'consistent' and 'correct' answer to this query, you would either have
> to lock the whole table while the sum was calculated or you would have
> to lock the rows as you read them"

true. But in Informix we use scroll cursor to do it.

BEGIN WORK
DECLARE SCROLL WITH HOLD CURSOR FOR SELECT .... COMMIT WORK The lock is held for a very short duration of time and COMMIT WORK releases the lock. However WITH HOLD retains the cursor after COMMIT and which become an immutable copy for that session as long as it wants.

Instead of SCROLL CURSOR, a TEMP TABLE can also be created for same.

I am sure same technique will work just fine in SQLServer.

Bottomline: this was never an issue in any enterprise RDBMS. Received on Tue Mar 30 2004 - 13:42:46 CST