XPost: comp.databases.oracle.misc, comp.databases.oracle.server   
   From: empty@zero.nil   
      
   Am Thu, 21 Oct 2004 09:37:42 -0400 schrieb Mark C. Stock   
   :   
   >   
   >   
   > did you try a standard UNIQUE constraint on the column?   
   >   
   > unlike SQL-Server (unless they've changed it since I last worked on it),   
   > Oracle processes null values properly in this scenario (i.e., one NULL   
   > value   
   > is never consider equal to another NULL value)   
      
   Yes, but it's a matter of convention because "NULL <> NULL" evaluates   
   to null and thus is also not true. So two null values should never   
   be considered different.   
      
   > ++ mcs   
   >   
   >   
      
   --   
   Frank Piron,   
   etfrankatkonaddotn   
   (leftrotate two)   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)