what is difference between cartesian join & cross join even
they give same result?
Answer Posted / 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 |
Post New Answer View All Answers
What is a trigger and what are its types in oracle?
What is transport network substrate (tns) in oracle?
How to get maxsal , minsal, ename department wise in single query
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
Explain the use of grant option in exp command.
What is the difference between post-database commit and post-form commit?
Explain do view contain data?
How many types of database triggers exist?
How to display row numbers with the records?
What to do if the startbd.bat failed to start the xe instance?
What is a nvl function?
What is oracle database client?
How to best split csv strings in oracle 9i?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What is the data pump import utility?