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

Joins allows you to read or report the data from more than 1 table. There are four types of joins are there..
1) equi join or inner join or natural join
2) non equi join
3) outer join
a)left outer join
b)right outer join
c)full outer join
4) self joins

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to get execution statistics reports on query statements?

1084


What are the differences between char and varchar2 in oracle?

1164


How to increment dates by 1 in oracle?

1066


Explain an integrity constrains?

1139


what is the use of system.effective.date variable in oracle?

1109


What are the different editions of oracle?

1103


what is the difference between functional dependecy and multilevel dependency?

2456


How to create a stored function in oracle?

1103


How to bring a tablespace offline?

1055


What happens to the data files if a tablespace is dropped?

1059


What is recycle bin in Oracle?

1145


Explain the difference between sap and oracle?

1029


What is save point in oracle database?

1289


What do database buffers contain?

1023


Point out the difference between user tables and data dictionary?

978