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

Home -> Community -> Usenet -> c.d.o.server -> Re: Implementing complicated constraints

Re: Implementing complicated constraints

From: Tony Andrews <andrewst_at_onetel.com>
Date: 29 Sep 2004 04:07:02 -0700
Message-ID: <1096456022.590105.46150@h37g2000oda.googlegroups.com>


Agoston Bejo wrote:
> I would like to do this so that the structure of the tables remain
the same.
> (Since in the real-life analogue of this example it is important that
the
> structures reflect the real-life concepts.)
>
> Anyway, the question is rather about the implementation of more
complicated
> constraints on tables than this specific example (which actually led
me to
> pose this question in the newsgroup).

Standard SQL has a syntax to support such multi-tabel constraints, but Oracle does not support it, so you have to use some kind of work around. I suggested one using a materialized view earlier, what do you feel about that? It is "declarative", and it doesn't involve changing your table design. Received on Wed Sep 29 2004 - 06:07:02 CDT

Original text of this message

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