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

Answer Posted / prem

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

Is This Answer Correct ?    5 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use group functions in the select clause using oracle?

594


How to revoke create session privilege from a user in oracle?

559


What are the various constraints used in oracle?

556


what is the scripts in data base?

1602


How to select some columns from a table in oracle?

553






Is oracle an operator?

534


How to specify default values in insert statement using oracle?

562


Where do we use decode and case statements?

563


What is the Tune Query

1845


How to use subqueries with the exists operator in oracle?

606


How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

546


Explain oracle left join with an example?

586


How to create a server parameter file?

571


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

590


What is the difference between postgresql and oracle?

505