Joins are used to fetch a query on more than one table. You can broadly ca

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

Question Posted / suresh

29 Answers
97213 Views
Amdocs, CSC, TCS, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Which is better Oracle or MS SQL? Why?

4960

What is null value in oracle?

1103

What is the difference between Delete, Truncate and Drop in Oracle?

1142

What is the difference between sharding and replication?

1062

Please explain drop constraint oracle?

1120

How to convert dates to characters in oracle?

1051

What is the usage of save points in oracle database?

972

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2375

How to assign data of the deleted row to variables?

1083

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2477

Is java required for oracle client?

1005

Â What are the oracle DML commands possible through an update strategy?

1073

Explain the use of constraints option in exp command.

1056

How will you differentiate between varchar & varchar2?

1049

How can you merge two tables in oracle?

1011