How to fix the Oracle error ORA-01719: outer join operator (+) not allowed in operand of OR or IN?

In this post, you’ll learn more about the Oracle ErrorORA-01719: outer join operator (+) not allowed in operand of OR or IN with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-01719: outer join operator (+) not allowed in operand of OR or IN

Reason for the Error ORA-01719: outer join operator (+) not allowed in operand of OR or IN

An outer join appears in an or clause.

How to fix the Error ORA-01719: outer join operator (+) not allowed in operand of OR or IN ?

You can fix this error in Oracle by following the below steps

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)).