Interested to Buy Any Domain ? << Click Here >> for more details...
what is a cartition product?
- 4 Answers
- 11800 Views
- I also Faced
- E-Mail Answers
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 executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
3. Display all the client numbers in the ORDER table. Remove duplicates.
What is difference between SUBSTR and INSTR?
How to open a cursor variable?
What do you mean by merge in oracle and how can we merge two tables?
what is load balancing and what u have used to do this?(sql loader)
What is Java Pool in Oracle?
How to rename an index in oracle?
What would you do with an in-doubt distributed transaction?
What is system tablespace?
What is use of oracle?
The join defined by the default data link is an outer join yes or no ?
Oracle General 
