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 select query statement in oracle?
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 ?
How to create a new table by selecting rows from another table?
What is oracle server autotrace in oracle?
How are extents allocated to a segment?
What happens if the update subquery returns multiple rows?
How to check database size in Oracle?
How to pass parameters to procedures in oracle?
How do I spool to a csv formatted file using sqlplus?
What is a cognitive schema?
Is postgres faster than oracle?
Can we create trigger on materialized view in oracle?
How to define an anonymous procedure without variables?
How to create a new table in your schema?
How can you merge two tables in oracle?