Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between cartesian join & cross join even
they give same result?
- 4 Answers
- 14632 Views
- Bank Of America, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shilpa
Both the joins give same result.Cross join is SQL 99 join
and Cartesian product is Oracle Propreitary join.
| Is This Answer Correct ? | 19 Yes | 2 No |
Answer / tapan
Both are giving same result but Cartesian product is oracle proprietary join and cross join is ANSI join .
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / prem
cross join gives some duplicate results but the cartesian
join give accurate result
| Is This Answer Correct ? | 5 Yes | 12 No |
What is a Data Segment ?
What is the difference between postgresql and oracle?
What is Read-Only Transaction ?
What is oracle database client?
Explain index?
How to create a testing table in oracle?
How to find the duplicate rows count from employees table in oracle?
What is the difference between substr & instr functions?
Give the constructs of a package, function or a procedure.
Explain oracle insert into command?
How to enter a new row into a table interactively?
List the parts of a database trigger.
Oracle General 
