what is difference between cartesian join & cross join even
they give same result?
- 4 Answers
- 13165 Views
- Bank Of America, I also Faced
- E-Mail Answers
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 |
Explain the importance of .pll extension in oracle?
What are the tools for Oracle ?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
How to start a specific oracle instance?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
Can group functions be mixed with non-group selection fields?
What is the difference between SQL and SQL Server?
Which is faster join or subquery in oracle?
What are the trigger associated with image items ?
State all possible different index configurations a table can possibly have?
How to define a specific record type?
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
Oracle General 
