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
- 9368 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 |
RMAN-08509: destination for restore of datafile string: string
ORA-00268: specified log file does not exist 'string'
ORA-07572: szrfc: insufficient rolename buffer space
LFI-01511: unlink() failed(OSD errno = string) in string.
ORA-38466: user does not have privileges to CREATE/MODIFY expressions
ORA-08179: concurrency check failed
ORA-29501: invalid or missing Java source, class, or resource name
LSX-00164: no content specified in "~S"
NZE-29245: the toolkit does not recognize the function being used
ORA-01696: controlfile is not a clone controlfile
NZE-29051: The given public key type is not supported.
QSM-01621: join backs to base tables not allowed with an equivalence
Oracle Errors 
