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

Home -> Community -> Usenet -> comp.databases.theory -> Re: UNIQUE and NULL in SQL

Re: UNIQUE and NULL in SQL

From: Gary Strader <gstrader_at_yahoo.com>
Date: 15 Jan 2002 12:40:03 -0800
Message-ID: <681fb18d.0201151240.4f9e267c@posting.google.com> 





brian-l-smith_at_uiowa.edu (Brian Smith) wrote in message news:<60360d48.0112291928.2e7c5818_at_posting.google.com>...


> I want the fourth insert statement above to succeed while still

> enforcing the UNIQUE constraint for non-null columns. Is that

> possible?




Yes - write an insert trigger to check it.  And ignore the
admonishments as to whether it's "correct" to do so since you probably
don't have the luxury to theorize about it.
Received on Tue Jan 15 2002 - 14:40:03 CST












Original text of this message













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