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 are joins..how many types of joins are there?

Answer Posted / shree

In SQL Server,Join actually puts data from two or more
tables into a sinle result set.
there are 3 types of joins
1.Inner join
2.Outer join
3.Cross join
In Oracle server
1. Equi Join
2.Non Equijoin
3.outer joins
4.self joins

Is This Answer Correct ?    47 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use "while" statements in oracle?

1232


Can multiple cursors being opened at the same time?

1018


How to recover a dropped table in oracle?

984


How to see free space of each tablespace?

968


What is translate in oracle?

1051


How to create a stored procedure in oracle?

1028


Please explain oracle data types with examples?

992


how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5333


How to bring a tablespace offline?

1001


Why we use bulk collect in oracle?

972


What is oracle in java?

913


How to pass parameters to procedures?

975


What is the difference between postgresql and oracle?

980


What are the various oracle database objects?

1093


How to convert raw data type into text in oracle? Explain

953