what is a cartition product?
- 4 Answers
- 11949 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 |
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
Who developed oracle & when?
Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ...
10 Answers Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon,
what is null value?
How do I find the database name in oracle?
Explain what are the different type of segments?
Explain oracle data types with examples?
What is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
what is difference between sql plus and sql*plus? (not sql and sql plus).
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
List the types of joins used in writing subqueries?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
Oracle General 
