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 -> Re: Cannot force antijoin in UPDATE (9.2.0.5.0)

Re: Cannot force antijoin in UPDATE (9.2.0.5.0)

From: Jaap W. van Dijk <j.w.vandijk_at_hetnet.nl>
Date: Fri, 15 Jun 2007 06:53:32 -0700
Message-ID: <1181915612.011952.88320@k79g2000hse.googlegroups.com> 






Charles Hooper schreef:



> Maybe the possibility of NULL values is causing the problem?

>

> Charles Hooper




Charles: that's it! I changed the column from NULL to NOT NULL, and
then the UPDATE was performed with an ANTIJOIN.



Thanks a million,



Jaap.
Received on Fri Jun 15 2007 - 08:53:32 CDT












Original text of this message













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