Re: Imposing Functional Dependencies

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Thu, 07 Feb 2002 20:02:35 GMT
Message-ID: <3C62DD5F.E7151801@ci.seattle.wa.us>

You can do this with a BEFORE INSERT trigger. Though you might want to also think about BEFORE UPDATE too if the values can be changed after insert.

Daniel Morgan

Yash wrote:

> Hi,
> I have a table myTable(A,B,C,D). I know that for a given C value, the
> value of D is fixed. Thus C functionally determines D. I don't want to
> normalise the table. I only want to enforce this constraint so that nobody
> inserts rows that have different values for the same value of C. How do I
> set the constarint? I am looking for the Oracle DDL statement in particular.
>
> Thanks.
Received on Thu Feb 07 2002 - 14:02:35 CST