cross join gives some duplicate results but the cartesian join give accur

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

Question Posted / prem

Answer Posted / prem

cross join gives some duplicate results but the cartesian
join give accurate result

Is This Answer Correct ?

5 Yes

12 No

Please Help Members By Posting Answers For Below Questions

How to use attributes of the implicit cursor in oracle?

1011

How to create a new table in oracle?

1161

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2106

What do you understand by a database object? Can you list a few of them?

1020

Can we connect to ORACLE db using Windows Authentication?

1264

What is BBED in Oracle?

1161

What is an oracle database?

1048

What is set operator oracle?

986

How to list all tables in your schema?

1055

How to update a table row with a record?

1016

How to fetch the row which has the max value for a column?

1002

What is a select query statement in oracle?

972

What is archive log in Oracle?

1135

how to clone 9i Database on to 10g Database.

2344

What is pragma autonomous transaction in oracle?

1074