ORA-01719 Error for a Select Query in 19c Database
(Doc ID 2740441.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 19.9.0.0.0 and later Information in this document applies to any platform.
Symptoms
ORA-01719 error for a Select Query in 19c Database
Same query works in Oracle 12c Database:
ORA-01719: outer join operator (+) not allowed in operand of OR or IN 01719. 00000 - "outer join operator (+) not allowed in operand of OR or IN" *Cause: An outer join appears in an or clause. *Action: If A and B are predicates, to get the effect of (A(+) or B), try (select where (A(+) and not B)) union all (select where (B)).
Changes
Upgrading the database from 12c to 19c
Cause
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
