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 oracle in java?
11. Display the client number and name and the client number and name of the person who referred that client.
Explain the difference between a procedure and a function?
what are the things that you consider while creating indexes on partitioning tables?
What is SAVE POINT ?
What is Database Buffers ?
How to drop an index?
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
please explain.. DB architecture ...
What is an Index ? How it is implemented in Oracle Database ?
How to drop a tablespace?