Re: Is this a bug, or am I loosing it

  • From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
  • To: jaykash@xxxxxxxxxxx
  • Date: Thu, 01 Feb 2007 13:44:21 -0700

This is not a bug, it's because of the NULLs and precisely the reason why not in and not exists are not equivalent whereas in and exists are. 


At 12:47 PM 2/1/2007, JayDBA wrote:
I am getting weird results from a NOT IN and NOT EXISTS query. Could this be because of NULL's or is it a bug? 

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com 
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email ______________________________________________________________________

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 02-2007