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 are named parameters?
What are the most common interview questions on ETL Testing for experience?
does the query needs a hint to access a materialized view?
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??
What is dual table oracle?
How to rename an index in oracle?
Why cursor variables are easier to use than cursors?
Can a formula column be obtained through a select statement ?
Explain the difference between a procedure and a function? What do you understand by those terms?
Calculate difference between 2 date / times in oracle sql?
Point out the difference between user tables and data dictionary?
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.
How to convert characters to times in oracle?
Why is oracle so popular?
What is raw datatype in oracle?