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