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...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

What are joins..how many types of joins are there?

Question Posted / mouli

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

What are operators in oracle?

1103

List out the difference between commit, rollback, and savepoint?

1095

What is sequence?

1137

How would you go about verifying the network name that the local_listener is currently using?

2110

How to create a stored program unit?

1321

How to start your 10g xe server from command line?

1130

How to drop a stored procedure in oracle?

1107

What is the usage of save points in oracle database?

1015

What are the different oracle database objects?

1150

What is execute immediate in oracle?

1078

How to get last row id?

1058

What is the sid in oracle?

1033

How to create a new table in your schema?

1130

What is archive log in Oracle?

1184

How to use group functions in the select clause using oracle?

1135