SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

To avoid cartesian results while joining more than 10tables

696613Apr 16 2009 — edited Apr 16 2009

hi to all,

In my oracle db im handling 15 tables and i have join all the
tables all together by using relationships .When i try to fetch any particular value in the where clause,
the outcome of the result is as a cartesian product.
How to avoid the cartesian results and what steps to follow in oracle (Cond: all the tables should clubbed)?

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on May 14 2009

Added on Apr 16 2009

6 comments

2,462 views