What are joins..how many types of joins are there?
Answer Posted / suresh
Joins are used to fetch a query on more than one table.
You can broadly catagorize joins in to four types.
1. Equi Join
2.Non Equijoin
3.outer joins
4.self joins
Is This Answer Correct ? | 140 Yes | 34 No |
Post New Answer View All Answers
How to write a query with a right outer join in oracle?
What is ADDM Advisor in Oracle?
How to see the table columns used in an index?
Explain what are clusters?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Explain joins in oracle?
Explain about functional dependency and its relation with table design?
How to drop an existing table in oracle?
what is the scenario where you take the database to NoArchivelog mode?
How to calculate date and time differences in oracle?
What do you mean by a deadlock?
what are actual and formal parameters?
what is IDE,DMV in sql server?
What is the purpose of save points in oracle database?
What is a trigger and what are its types in oracle?