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


Please Help Members By Posting Answers For Below Questions

What is a select query statement in oracle?

618


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 ?

2126


How to create a new table by selecting rows from another table?

643


What is oracle server autotrace in oracle?

707


How are extents allocated to a segment?

665






What happens if the update subquery returns multiple rows?

691


How to check database size in Oracle?

728


How to pass parameters to procedures in oracle?

669


How do I spool to a csv formatted file using sqlplus?

619


What is a cognitive schema?

605


Is postgres faster than oracle?

641


Can we create trigger on materialized view in oracle?

668


How to define an anonymous procedure without variables?

628


How to create a new table in your schema?

695


How can you merge two tables in oracle?

658