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: Comapring tables from two databases
Next Topic: What is the functionality of NO_UNNEST hint?
Goto Forum:

Current Time: Thu Aug 24 01:58:34 CDT 2017

Total time taken to generate the page: 0.13558 seconds