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
- 9514 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-27126: unable to lock shared memory segment in core
IMG-00553: invalid rotate value
DRG-11862: This Is Probaly A HTTP Server 0.9 Or Less
ORA-13410: invalid layerNumbers or bandNumbers parameter
ORA-12986: columns in partially dropped state. Submit ALTER TABLE DROP COLUMNS CONTINUE
ORA-13278: failure to convert SRID to native format
ORA-09801: Unable to get user ID from connection
ORA-01342: LogMiner can not resume session due to inability of staging checkpointed data
LPX-00659: Output write failed.
ORA-27230: OS system call failure
QSM-01024: materialized view, string, has unknown compile errors
ORA-39954: DEFERRED is required for this system parameter
Oracle Errors 
