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 would you change old and new values in an insert, delete and update triggers?
What is a trace file and how is it created in oracle?
Name the three major set of files on disk that compose a database in Oracle?
What is Data Block ?
How to create a temporary table in oracle?
select statement does not retrieve any records. what exception is raised?
How to check database size in Oracle?
What are the different types of databases?
where do i find oracle interview questions.
What are the type of Synonyms?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
How to get last row id?