what is difference between cartesian join & cross join even
they give same result?
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 |
How to use attributes of the implicit cursor in oracle?
How to rename an index?
What is the difference between substr & instr functions?
what is data independence exactly? give an example
How does one get the view definition of fixed views/tables?
What is parameterized cursor in oracle?
How do I reset a sequence in oracle?
What is the difference between online and offline backups?
What are the different types of synonyms?
What is a select query statement in oracle?
What are different Oracle database objects?
How to login to the server without an instance?