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
How to use group functions in the select clause using oracle?
How to revoke create session privilege from a user in oracle?
What are the various constraints used in oracle?
what is the scripts in data base?
How to select some columns from a table in oracle?
Is oracle an operator?
How to specify default values in insert statement using oracle?
Where do we use decode and case statements?
What is the Tune Query
How to use subqueries with the exists operator in oracle?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
Explain oracle left join with an example?
How to create a server parameter file?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
What is the difference between postgresql and oracle?