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 do you know about normalization? Explain in detail?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
What are the restrictions on external table columns?
What is concurrency in oracle?
What happens if you lost a data file?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is the difference between 10g OEM and 11g OEM?
How to store only time; not date and time?
Differentiate between post-database commit and post-form commit?
Explain the difference between replace() and translate() functions in oracle?
How to create a new table by selecting rows from another table?
What is query image?
In what script is snap$ created? In what script is the scott/tiger schema created?
What is a cursor and what are the steps need to be taken?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?