Re: "Transactions are bad, real bad" - discuss
From: Mikito Harakiri <mikharakiri_at_ywho.com>
Date: Wed, 30 Apr 2003 14:59:19 -0700
Message-ID: <5NXra.8$i92.264_at_news.oracle.com>
Date: Wed, 30 Apr 2003 14:59:19 -0700
Message-ID: <5NXra.8$i92.264_at_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 - 23:59:19 CEST