ORA-01719: outer join operator (+) not allowed in operand of
OR or IN
- 2 Answers
- 9006 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 |
ORA-17510: Attempt to do i/o beyond file size
ORA-25258: cannot register for notifications on an 8.0 style exception queue
ORA-30114: error when processing from command line
KUP-04002: error getting file size for file string
ORA-09888: osnTXtt: txipc channel creation failed
ORA-01528: EOF while processing SQL statement
ORA-40262: NMF: number of features not between [1, string]
PLS-01702: Illegal syntax in COMMIT WORK statement
PCB-00204: Group items cannot be used except in INTO or VALUES clause
ORA-32055: invalid file type
ORA-13769: Snapshots string and string do not exist.
PLS-00586: a static method cannot declare a parameter named SELF
Oracle Errors 
