ORA-01719 Error for a Select Query in 19c Database
(Doc ID 2740441.1)
Last updated on APRIL 17, 2023
Oracle Database - Enterprise Edition - Version 188.8.131.52.0 and later Information in this document applies to any platform.
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)).
Upgrading the database from 12c to 19c
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!