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
- 9511 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-07580: spstp: $GETJPIW failure
ORA-13755: invalid "SQL Tuning Set" name
ORA-08463: overflow converting decimal number to Oracle number
ORA-04013: number to CACHE must be less than one cycle
ORA-29273: HTTP request failed
ORA-36956: (XSFCAST25) There are only number PERIODICITY values. You cannot specify more OFFSET values.
ORA-02377: invalid resource limit
ORA-01288: file string is from a different database incarnation
IMP-00007: must be a DBA to import objects to another user's account
PCC-00101: Lower case 'e' in floating point number is not ANSI
ORA-00030: User session ID does not exist.
ORA-09744: smsget: mmap returned an error.
Oracle Errors 
