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

Question Posted / guest

2 Answers
8547 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / guest

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

Please add more information about this Error

Is This Answer Correct ?

5 Yes

1 No

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

Answer / krishna m m

Action: If A and B are predicates, to get the effect of
(A(+) or B),
try (select where (A(+)) union (select where (B)).

But union will take more time. This will tend to perofmance
issue, if the records are more.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer