Interested to Buy Any Domain ? << Click Here >> for more details...
what is a cartition product?
- 4 Answers
- 11430 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 |
Can we convert a date to char in oracle and if so, what would be the syntax?
How to declare a local variable?
What is data file?
What is open database communication (odbc) in oracle?
What is hash cluster in oracle?
Explain the difference between a procedure and a function? What do you understand by those terms?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!
material view and view disadvantages?
What is memory advisor in Oracle?
What would you do if a database crashes in production?
Oracle General 
