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 |
ORA-31601: Function string cannot be called now that fetch has begun.
ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified
ORA-13628: Insufficient privileges to access the task belonging to user string
ORA-23435: cannot create an updatable ROWID materialized view with LOB columns
IMP-00047: unexpected file sequence number; expected number but found number
SQL*Loader-00646: lob set to EMPTY in column string, row number, table string
ORA-06607: LU6.2 Driver: Reset occurred in send state
RMAN-06555: datafile string must be restored from backup created before string
QSM-01105: no primary key or row id in MV, string, is found for table, string
PLS-00730: collection element type does not allow modifications
ORA-19031: XML element or attribute string does not match any in type string.string
PLS-00567: cannot pass NULL to a NOT NULL constrained formal parameter