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 -> Any way to do "unique or null"?

Any way to do "unique or null"?

From: Roy Smith <roy_at_popmail.med.nyu.edu>
Date: Tue, 08 Sep 1998 11:45:04 -0400
Message-ID: <roy-0809981145040001@qwerky.med.nyu.edu>


I've got a column which I want to allow to be null, but if there is a value in it, I want to ensure that value is unique amongst the non-null entries. Can a constraint be used to do this?

--
Roy Smith <roy_at_popmail.med.nyu.edu>
New York University School of Medicine Received on Tue Sep 08 1998 - 10:45:04 CDT

Original text of this message

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