Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


ORA-01719: outer join operator (+) not allowed in operand of
OR or IN

Answers were Sorted based on User's Feedback



ORA-01719: outer join operator (+) not allowed in operand of OR or IN..

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

ORA-01719: outer join operator (+) not allowed in operand of OR or IN..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-31601: Function string cannot be called now that fetch has begun.

1 Answers  


ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified

1 Answers  


ORA-13628: Insufficient privileges to access the task belonging to user string

1 Answers  


ORA-23435: cannot create an updatable ROWID materialized view with LOB columns

1 Answers  


IMP-00047: unexpected file sequence number; expected number but found number

1 Answers  


SQL*Loader-00646: lob set to EMPTY in column string, row number, table string

1 Answers  


ORA-06607: LU6.2 Driver: Reset occurred in send state

1 Answers  


RMAN-06555: datafile string must be restored from backup created before string

1 Answers  


QSM-01105: no primary key or row id in MV, string, is found for table, string

1 Answers  


PLS-00730: collection element type does not allow modifications

1 Answers  


ORA-19031: XML element or attribute string does not match any in type string.string

1 Answers  


PLS-00567: cannot pass NULL to a NOT NULL constrained formal parameter

1 Answers  


Categories