Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between cartesian join & cross join even
they give same result?
- 4 Answers
- 14651 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 |
How to load excel data sheet to oracle database
how many columns can a plsql table have
Explain the use of record option in exp command.
how to get last monday of a month?
what's query optimization and without use of IN AND Exist can we get another way data from query
What is a Private Synonyms ?
acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account
How to change program global area (pga) in oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How can I combine multiple rows into a comma-delimited list in oracle?
What is a heap related to database ?
1 Answers TCS, University of Edinburgh,
What is the order of defining local variables and sub procedures/functions?
Oracle General 
