Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Help with SQL constraint
Hello all,
A table T has 2 fields, one (L) holding letters 'Y' and 'N', and one
(X) holding numbers. Is there a (non trigger) constraint such that for
L='N' (and only this letter) the numbers must be unique? Records
where L='Y' do not have to be unique.
(I need to join another table to the L='N' group of records, and the
join must be key-preserved).
Cheers,
Dean Received on Wed Feb 14 2007 - 20:37:36 CST