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 |
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is a schema in oracle?
What are the various oracle database objects?
How to unlock the sample user account in oracle?
what is reindexing?
What are synonyms used for ?
In oracle there is column command, how will you explain that?
Whats the benefit of dbms_stats over analyze?
How do I manually uninstall oracle client?
"primary key=unique+null" is equal,reson?not,reason?
What is using clause and give example?