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

How do I reset a sequence in oracle?

1098


What are transaction isolation levels supported by oracle?

1072


State some uses of redo log files?

1010


How to convert numbers to characters in oracle?

1030


What is an oracle database?

1036


What are the differences between primary key and unique key?

1010


How do I spool to a csv formatted file using sqlplus?

1034


Explain about your project and its relation to the current job position you are applying to?

1011


I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2185


State any two functions of oracle?

1046


How to apply filtering criteria at group level in oracle?

1042


Can we write dml statement in function in oracle?

1082


How to view the tablespaces in the current database?

978


How to connect the oracle server as sysdba?

1078


What is the sql query to concatenate column values from multiple rows in oracle?

1056