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

The following is the cause of this error:

An outer join appears in an or clause.

Action you can take to resolve this issue: 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)).

Tags: Database, Microsoft, SQL, Oracle, Software, DBMS

Related