Re: Implementing complicated constraints

"Tony Andrews" <andrewst_at_onetel.com> wrote in message news:1096456022.590105.46150_at_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.
|

tony, how would the materialized view help enforce the OP's needed constraint? what do you have in mind?

++ mcs Received on Wed Sep 29 2004 - 06:42:06 CDT