Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Can these constraint be implemented in an RDBMS ?

Re: Can these constraint be implemented in an RDBMS ?

From: Mikito Harakiri <mikharakiri_at_iahu.com>
Date: Tue, 2 Mar 2004 09:23:56 -0800
Message-ID: <Rz31c.24$4E5.432@news.oracle.com>


"ben brugman" <ben_at_niethier.nl> wrote in message news:4044ac1c$0$3681$4d4ebb8e_at_read.news.nl.uu.net...
> The problem is derived from two accounts which together are not
> allowed to be negative. (Used to illustrate Oracle's failure to implement
> serializability (as defined in most dictionaries and in the
SQL-standard).)
> Most solutions I have seen involve some application coding. And often
> a denial that you actually want those constraints.

Discussing serializability might be interesting. Could you please reduce the problem to possibly no more than 1-2 tables? An example involving half dozen tables is overkill. Received on Tue Mar 02 2004 - 11:23:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US