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 -> Unique constraint over 2 columns with allowable NULLs

Unique constraint over 2 columns with allowable NULLs

From: mikew01 <mikew01_at_blueyonder.co.uk>
Date: Thu, 29 Nov 2007 07:36:00 -0800 (PST)
Message-ID: <9ac78184-cdee-44b5-9816-5f6d7889b701@l1g2000hsa.googlegroups.com> 





Hello, I need to add a unique constraint over 2 columns where one of
the columns could be NULL.


A standard UNIQUE constraint applied over these 2 columns will break
when someone tries to put a second NULL into the allowable NULL column
so Im wondering how to go about enforcing this constraint?



TIA

Received on Thu Nov 29 2007 - 09:36:00 CST












Original text of this message













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