Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help with SQL constraint
On Feb 14, 9:54 pm, DA Morgan <damor..._at_psoug.org> wrote:
> dean wrote:
> > 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
>
> What version of Oracle and what's wrong with a trigger?
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
Sorry, its 10g and 9.2i. The reason is I want to join on this set of records, and make the result key preserved so that the other table is updatable. Received on Wed Feb 14 2007 - 21:20:17 CST