Re: "Transactions are bad, real bad"

From: Mikito Harakiri <mikharakiri_at_ywho.com>
Date: Wed, 30 Apr 2003 14:59:19 -0700
Message-ID: <5NXra.8$i92.264@news.oracle.com>

"Paul Vernon" <paul.vernon_at_ukk.ibmm.comm> wrote in message news:b8ljgd$383i$3_at_gazette.almaden.ibm.com...
> With transactions, this rule is compromised. A user could simply open a
> transaction before the end of the 1 hour deadline, make a bid at then only
> decide to commit (or rollback) the bid at his leisure after the end of the
> deadline.

Isn't this problem trivally solved by "flashback" query that auction organizer can run?

select max(amount) from bids AS OF "30-APR-2002 12:00"

Any transaction not committed before "30-APR-2002 12:00" would have no effect onto the query resultset. Received on Wed Apr 30 2003 - 16:59:19 CDT

Re: "Transactions are bad, real bad" - discuss