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

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

Answer Posted / t.murali krishna

Types of joins:
1. Inner join
equi join
non equi join
selfjoin
2.Outer join
left outer
right outer
full outer(from 9i)
3.Natural join(from 9i)
4.cross join

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a cursor in oracle?

1232


Is oracle the best database?

1011


How to define a variable to match a table column data type?

1039


How to download oracle database 10g xe?

1068


How to use "out" parameter properly?

1125


Explain rename?

1046


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2065


How to assign values to data fields in record variables?

1080


How many types of segments in Oracle?

1117


What is ordinary table in oracle?

1243


What is meant by a deadlock situation?

1156


Why do we use bulk collect in oracle?

1108


What is the implicit cursor in oracle?

1173


Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2231


What the is the diff between local index and global index. give some example.

1685