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

Answer Posted / suresh

Joins are used to fetch a query on more than one table.
You can broadly catagorize joins in to four types.
1. Equi Join
2.Non Equijoin
3.outer joins
4.self joins

Is This Answer Correct ?    140 Yes 34 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to define a data source name (dsn) in odbc manager?

1034

What is meant by an index?

1145

What is ordinary table in oracle?

1159

What is ASM (Automatic Storage Management) in Oracle?

1196

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

1073

Will you be able to store pictures in the database?explain.

992

What is a initialization parameter file in oracle?

1035

How much memory your 10g xe server is using?

1103

What is hash cluster in oracle?

1174

Where do we use decode and case statements?

1013

What is merge in oracle?

1054

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

2007

What is SQL access advisor in Oracle?

1191

What is private procedure oracle?

1012

How many types of tables supported by oracle?

1077