Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01719: outer join operator (+) not allowed in operand of
OR or IN
- 2 Answers
- 9613 Views
- I also Faced
- E-Mail Answers
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 |
PLS-00243: invalid external type specification for SQLNAME
ORA-01372: Insufficient processes for specified LogMiner operation
IMG-02005: 2FF05 - incorrect color specification
ORA-09344: spsig: error signalling thread
ORA-36200: (XSAGGR34) AGGREGATE operator string requires a WEIGHTBY clause, but ARGS variable workspace object did not specify one.
CLSR-00516: No service provider found at this node
PLS-00376: illegal EXIT statement; it must appear inside a loop
TNS-12656: Cryptographic checksum mismatch
RMAN-06428: recovery catalog is not installed
RMAN-08096: channel string: starting validation of datafile backupset
ORA-01298: conflicting dictionary option
ORA-07468: spwat: mset error, unable to set semaphore.
Oracle Errors 
