Wrong Results (Zero Rows) Returned from Anti-Join
(Doc ID 2749870.1)
Last updated on MARCH 31, 2021
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
An anti-join returns wrong results.
A query contains a NOT EXISTS, correlated subquery. For example,
This query returns zero rows, whereas one row is expected in the result set.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document