what is a cartition product?
Answers were Sorted based on User's Feedback
Answer / guneetinder singh
it is the resultant relation from the two relation in the
sense that every element of first column in first table is
linked with every element of second relations first column.
E.G.
A={1,2}
b={3,4}
Cartesian product is = {(1,3)(1,4)(2,3)(2,4)}
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / patilshashi
a query with no where clause in it, it will return no of
rows of first table multiplied by no of rows of second table
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ron
Cartesian product includes rows from all the tables where
there is no specific criteria to join on.
it does not necessarily mean that there is no where clause
it can have a where clause where you filter data set from
table a, table b, c... and then join these tables to give
you the product of the join.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sony
If A and B are two sets the AxB is the cartetion product of
A and B
| Is This Answer Correct ? | 1 Yes | 0 No |
i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?
How to concatenate two text values in oracle?
What is transport network substrate (tns) in oracle?
What are the oracle differences between nvl and coalesce
How to bring a tablespace online?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
What is difference between Rename and Alias?
Why cursor variables are easier to use than cursors?
What is tns name?
How to assign a table row to a record variable?
what is kernel?
what is pragma?