What is a Cartesian product?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is a Cartesian product?
Rating:
A join, between two or more tables, with no join condition results in a Cartesian product. A Cartesian product is a set of all possible combinations of rows drawn from each table involved in the join. In other words, Oracle combines each row of one table with each row of the other table. For example, the Cartesian product of two tables with five rows each, has twenty-five rows.
Rating:
Was this information helpful?
Other articles
- What are the guidelines for naming a column?
- What is NVL function?
- What are database objects?
- What is TO_CHAR (number) function?
- What is DECODE function?