Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unique NULLs?
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