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 / srikanth keshavena

Answer Posted / srikanth keshavena

Basically join's are three type's those are :

1.Cross join
2.Equi join
a.Natural join
b.inner join
c.outer join(Simple join)
i.Left outer join
ii.Right outer join
iii.FUll outer join
3.Non-equi join

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is index-organized table in Oracle?

1018

What are the various constraints used in oracle?

991

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

929

Is primary key indexed by default in oracle?

929

How remove data files before opening a database?

997

Is there any function in oracle similar like group_concat of mysql?

986

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

977

How to delete a user account in oracle?

912

How to shutdown your 10g xe server?

1082

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2206

What is a trigger and what are its types?

1113

Explain the use of owner option in exp command.

990

How do we get field details of a table?

932

What is the meaning of recursive hints in oracle?

993

How to create a stored program unit?

1116