Both are giving same result but Cartesian product is oracle proprietary joi

what is difference between cartesian join & cross join even
they give same result?

Question Posted / tapan

Answer Posted / tapan

Both are giving same result but Cartesian product is oracle proprietary join and cross join is ANSI join .

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to connect asp pages to oracle servers?

1007

How to retrieve values from data fields in record variables?

1036

How many anonymous blocks can be defined?

1104

Differentiate between translate and replace?

1040

What is index in Oracle?

1014

What is a table index?

1013

What suggestions do you have to reduce the network traffic?

901

How does Oracle guarantee data integrity of data changes?

2333

Why do you use stored procedures and state some of its disadvantages?

970

What is a lookup table in oracle?

934

How do we display rows from the table without duplicates?

920

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1059

Explain oracle left join with an example?

956

Who developed oracle & when?

944

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1012