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

Answer Posted / pravin

Joins are used to fetch data or information from one or
more tables and there are five types of join.
1. Inner Join
2. Outer Join
3. Self Join
4. Cross Join
5. Exception Join

Is This Answer Correct ?    27 Yes 40 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to specify default values in insert statement using oracle?

1116

How to rename an index in oracle?

1123

How to invoke the data pump import utility?

1179

Write a syntax for update query in oracle?

1044

What is background process in Oracle?

1110

Briefly explain what is literal? Give an example where it can be used?

1057

How many types of database triggers exist?

1144

What is a dead lock in oracle?

1135

How to use subqueries in the from clause in oracle?

1120

What language does oracle use?

1119

How to use values from other tables in update statements using oracle?

1088

Is insert autocommit in oracle?

1083

What is a cursor and what are the steps need to be taken?

1213

Why does oracle 9i treat an empty string as null?

1071

How does one get the view definition of fixed views/tables?

1031