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

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

More Oracle Errors Interview Questions

RMAN-11001: Oracle Error: string

1 Answers  


ORA-28533: Heterogeneous Services coercion handling error

1 Answers  


ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

1 Answers  


NNL-00543: [show] version [<server_list>] : show the name and version of one or more Names servers

1 Answers  


DRG-52203: invalid object name: string

1 Answers  






TNS-01157: Can only listen on number addresses - ignoring string

1 Answers  


TNS-00271: Connection Manager

1 Answers  


ORA-30388: name of the rewrite equivalence is not specified

1 Answers  


ORA-30085: syntax error was found in overlaps predicate

1 Answers  


ORA-27414: Invalid BY value type

1 Answers  


ORA-03002: operator not implemented

1 Answers  


ORA-14102: only one LOGGING or NOLOGGING clause may be specified

1 Answers  


Categories