Re: Help with SQL constraint

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 15 Feb 2007 08:42:15 -0800
Message-ID: <1171557732.482050@bubbleator.drizzle.com>

dean wrote:

> 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.

I asked: "what's wrong with a trigger"

You responded: "I want to join"

?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Thu Feb 15 2007 - 10:42:15 CST