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 insert the image in table
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How to speed up webrick?
From the database level, how can you tell under which time zone a database is operating?
Explain parameter file in oracle.
Can we save images in a database and if yes, how?
what is a cartition product?
How to convert numbers to characters in oracle?
How to save query output to a local file?
Explain oracle instance.
What is a trace file and how is it created in oracle?
what r routers?