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 difference between UNION AND UNIONALL
What is ASM (Automatic Storage Management) in Oracle?
write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000
What is snapshot is too old? Give and example for better understand.
Explain the use of indexes option in imp command.
What is a Segment ?
What is bulk load in oracle?
What is logical backup in oracle?
What is a server parameter file in oracle?
why pl sql doesn't support retrieving multiple records
Explain oracle data types with examples?
What is tns name?