Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Imposing Functional Dependencies
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 Wed Feb 06 2002 - 21:56:51 CST