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 have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
how to store only time in a data base table
What are joins, explain all types of joins?
What is the difference between Outer join and Full outer join?
how to get the no employee in each department including the dept which has 0 employee
How many anonymous blocks can be defined?
what is IDE,DMV in sql server?
What is hot backup and logical backup?
Which is better Oracle or MS SQL? Why?
How does the on-delete-cascade statement work?
What is enter substitution variable in oracle?
What is data file?