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 |
How to create tables for odbc connection testing?
What is bulk collect in oracle?
What is proxy method?
How to connect to a remote server?
How to drop an index in oracle?
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.
How you open and close a cursor variable.Why it is required?
How to define a specific record type?
SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.
What is a subquery?
Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)
i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table