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 |
Can a parameter be passed to a cursor?
what are indexes..how many types of index's are there and what are they?
7 Answers Green Info Solutions, TCS,
Can we save images in a database and if yes, how?
How to empty your oracle recycle bin?
Write a syntax for update query in oracle?
What is a static data dictionary in oracle?
What is a Data File ?
how to tune oracle sql queries pls tell me step by step. urgent pls
What is TNS File
How to drop an existing table in oracle?
What is the difference between post-database commit and post-form commit?
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?