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

Why is oracle database so popular?

1020


How index is implemented in oracle database?

1013


Explain the use of record length option in exp command.

1075


How to delete a column in an existing table?

1082


What is oracle rowcount?

1093


How does the on-delete-cascade statement work?

1127


What is a nvl function?

1041


what are the default admin accounts in Oracle 10g ?

980


Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

1027


What is analyze command used for?

1082


What are the execution control statements in oracle?

1102


What is an oracle wallet?

952


How to use attributes of the implicit cursor in oracle?

1016


What is a Garbage Collection? and what is full recursive Garbage collection?

2912


What do you mean by merge in oracle?

1003