Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Implementing complicated constraints
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