Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Unique constraint and NULL values

Re: Unique constraint and NULL values

From: <ctcgag_at_hotmail.com>
Date: 21 Oct 2004 16:23:01 GMT
Message-ID: <20041021122301.861$C2@newsreader.com>


"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote:

> yes, in theory, the SQL Server approach is more 'pure', but in practice,
> the Oracle approach is more practical (i'm starting to sound like yogi
> berra!)
>
> if i'm creating a UNIQUE constraint, my goal is to disallow values that
> are known to be equal to other known values -- so, it's entirely
> appropriate to not disallow (sorry for the double-negs) unknown values
> (triple-negs?) since there is no known basis for excluding them

But then why does it exclude them when there are other columns present?

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB
Received on Thu Oct 21 2004 - 11:23:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US