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 NULLs?

Re: Unique NULLs?

From: TurkBear <johng_at_mm.com>
Date: Wed, 08 Dec 1999 18:01:14 GMT
Message-ID: <384e9ba3.7131023@super.news-ituk.to>


fields do not have records, records have fields, fields have values...in any case, a NULL cannot be unique, since NULL is not comparable to any other value even itself - A unique field, by definition in Oracle, is a NOT NULL field, so you cannot have one with NULL as its value...

"W. Scott Moore" <sirws_at_hotmail.com> wrote:

>Is it possible to create a Unique field that can have one, and only one,
>null record in it?
>
>TIA,
>Scott
>

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Wed Dec 08 1999 - 12:01:14 CST

Original text of this message

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