9.2i, 10g, Windows, Linux.


Is there a way to say that for table T (fields F1, F2, F3), that for
all distinct pairs F1, F2, the value of F3 must be the same? That is,
if there are N rows all with the same values of F1 and F2, that they
ALL hold the same value in F3? I appreciate the obvious way of doing
this with another table and a FK with F1 and F2 and a unique 3rd
column, but I'm not sure if there is a way to do this without the need
for a second table.

Thanks for any help.

Dean

On Jul 2, 5:13 pm, dean <deanbrow...@yahoo.com> wrote:
> 9.2i, 10g, Windows, Linux.
>
> Is there a way to say that for table T (fields F1, F2, F3), that for
> all distinct pairs F1, F2, the value of F3 must be the same? That is,
> if there are N rows all with the same values of F1 and F2, that they
> ALL hold the same value in F3? I appreciate the obvious way of doing
> this with another table and a FK with F1 and F2 and a unique 3rd
> column, but I'm not sure if there is a way to do this without the need
> for a second table.
>
> Thanks for any help.
>
> Dean

Actually removing F3 from T and setting up another table with F1, F2,
F3 is the only solution which is relationally correct.

--
Sybrand Bakker
Senior Oracle DBA