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
abdul_rafeekh
Messages: 3
Registered: December 2006
Location: hyderabad
Junior Member

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

Rafeekh..
Re: Cartesian product in joins [message #248224 is a reply to message #248222] Thu, 28 June 2007 06:13 Go to previous message
arunprasad_bh
Messages: 32
Registered: June 2007
Member
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: Wed Dec 07 04:53:43 CST 2016

Total time taken to generate the page: 0.10200 seconds