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 are named parameters?

618


What are the most common interview questions on ETL Testing for experience?

603


does the query needs a hint to access a materialized view?

1470


In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1369


What is dual table oracle?

529






How to rename an index in oracle?

624


Why cursor variables are easier to use than cursors?

577


Can a formula column be obtained through a select statement ?

1849


Explain the difference between a procedure and a function? What do you understand by those terms?

626


Calculate difference between 2 date / times in oracle sql?

576


Point out the difference between user tables and data dictionary?

548


Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

1871


How to convert characters to times in oracle?

600


Why is oracle so popular?

567


What is raw datatype in oracle?

590