Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What do you know about normalization? Explain in detail?

946


I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2305


What are the restrictions on external table columns?

1052


What is concurrency in oracle?

1005


What happens if you lost a data file?

1034


How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1897


What is the difference between 10g OEM and 11g OEM?

963


How to store only time; not date and time?

1016


Differentiate between post-database commit and post-form commit?

1031


Explain the difference between replace() and translate() functions in oracle?

1034


How to create a new table by selecting rows from another table?

1076


What is query image?

979


In what script is snap$ created? In what script is the scott/tiger schema created?

2708


What is a cursor and what are the steps need to be taken?

1196


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?

1040