标题: ORA-01719: outer join operator (+) not allowed in operand of OR or IN [打印本页] 作者: admin 时间: 2016-7-18 15:11 标题: ORA-01719: outer join operator (+) not allowed in operand of OR or IN ORA-01719: 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)).