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

Home -> Community -> Usenet -> c.d.o.misc -> Re: unique constraints

Re: unique constraints

From: Bunyip <noname_at_domain.net>
Date: Mon, 5 Apr 1999 07:59:57 +1000
Message-ID: <7e8mtb$e37$1@m2.c2.telstra-mm.net.au>


Logically, a Null repersents an UNKNOWN value. Therfore it's value is unique in the sense that it is unknown.

B.

Prasad wrote in message <37074AB8.23FD_at_inspire.net.nz>...
>Hai!
>I want to know how oracle reads the null values
>on a column defined with unique constraint . Plese clarify whether
>null is treated as same or different on each row.
>
>I will be very much thankful for an early reply
>kep
Received on Sun Apr 04 1999 - 16:59:57 CDT

Original text of this message

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