Ask Google

Custom Search

Saturday, February 19, 2011

Ask Java 3

What is a cartesian product in PL/SQL?

 When a Join condition is not specified by the programmer or is invalid(fails), PL/SQL forms a Cartesian product.

In a Cartesian product, all combinations of rows will be displayed.

For example, All rows in the first table are joined to all rows in the second table. It joins a bunch of rows and it's result is rarely useful unless you have a need to combine all rows from all tables. 


No comments:

Post a Comment


  © Blogger template The Beach by 2009

Back to TOP