ORA-01719: outer join operator (+) not allowed in operand of
OR or IN
Answers were Sorted based on User's Feedback
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 |
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 |
RMAN-11001: Oracle Error: string
ORA-28533: Heterogeneous Services coercion handling error
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
NNL-00543: [show] version [<server_list>] : show the name and version of one or more Names servers
DRG-52203: invalid object name: string
TNS-01157: Can only listen on number addresses - ignoring string
TNS-00271: Connection Manager
ORA-30388: name of the rewrite equivalence is not specified
ORA-30085: syntax error was found in overlaps predicate
ORA-27414: Invalid BY value type
ORA-03002: operator not implemented
ORA-14102: only one LOGGING or NOLOGGING clause may be specified