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 / guruswamy

join is combaining two or more tables.
there are three types.they are
1).simple join
2).self join
3).3.outer joins

Is This Answer Correct ?    15 Yes 21 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to drop an existing table in oracle?

1058


Why we use bulk collect in oracle?

1046


How many types of table in Oracle?

1128


How to invoke the data pump export utility?

1191


What is meant by a deadlock situation?

1111


Can we insert data in view oracle?

1042


How to retrieve values from data fields in record variables?

1120


 How to use an oracle sequence generator in a mapping?

1076


src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1690


How to use "out" parameter properly?

1084


what is meant by magic query

2189


How does Oracle guarantee data integrity of data changes?

2393


Explain a segment?

1093


What are the extensions used by oracle reports?

1039


Explain the function of optimizer in oracle?

1146