Home » SQL & PL/SQL » SQL & PL/SQL » Cartesian product in joins
Cartesian product in joins [message #248222] Thu, 28 June 2007 05:59 Go to next message
Messages: 3
Registered: December 2006
Location: hyderabad
Junior Member

could any body tell me "Is cartesian product is useful and how it can be useful??

Re: Cartesian product in joins [message #248224 is a reply to message #248222] Thu, 28 June 2007 06:13 Go to previous message
Messages: 32
Registered: June 2007
It can be useful when you want to normalise data.
suppose you want 10 rows from each record.
then you may use cartesian product.

You may use a rownum to identify the records, then may be case to eliminate if you have any conditions for qualifying rows.
Previous Topic: TRYKY QUERY
Next Topic: Is there any concept of "Illipses" in Oracle?
Goto Forum:

Current Time: Fri Oct 21 23:27:21 CDT 2016

Total time taken to generate the page: 0.30871 seconds