Go to the FreeLists Home Page Home Signup Help Login
 



[oracle-l] || [Date Prev] [02-2007 Date Index] [Date Next] || [Thread Prev] [02-2007 Thread Index] [Thread Next]

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 ______________________________________________________________________




[ Home | Signup | Help | Login | Archives | Lists ]

All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
Everything else ©2007 Avenir Technologies, LLC.