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

Answer Posted / shree

In SQL Server,Join actually puts data from two or more
tables into a sinle result set.
there are 3 types of joins
1.Inner join
2.Outer join
3.Cross join
In Oracle server
1. Equi Join
2.Non Equijoin
3.outer joins
4.self joins

Is This Answer Correct ?    47 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use "while" statements in oracle?

1232

Can multiple cursors being opened at the same time?

1018

How to recover a dropped table in oracle?

984

How to see free space of each tablespace?

968

What is translate in oracle?

1051

How to create a stored procedure in oracle?

1028

Please explain oracle data types with examples?

992

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5333

How to bring a tablespace offline?

1001

Why we use bulk collect in oracle?

972

What is oracle in java?

913

How to pass parameters to procedures?

975

What is the difference between postgresql and oracle?

980

What are the various oracle database objects?

1093

How to convert raw data type into text in oracle? Explain

953