various types of joins

Categories >> Software >> Databases >> Oracle >> Oracle General
Suggest New Category

Question Posted / jakki

9 Answers
8105 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

various types of joins..

Answer / raj

Outer Join, Inner Join and self join

Is This Answer Correct ?

8 Yes

1 No

various types of joins..

Answer / samir kumar sahoo

Generally there are five types of joins in oracle:

Self Join
Equi Join
Cartesian Join
Outer Join(Left outer join,Right outer join)
Non_Equi JOin

Is This Answer Correct ?

7 Yes

0 No

various types of joins..

Answer / s. senthil kumar

There are Two Types of joins:

I. Inner Join
II. Outer Join

I: Inner join:a) Equi join, b) Non Equi join c) self join
II: Outer join: a) Left outer join, b) right outer join,
c) Full outer join

Is This Answer Correct ?

6 Yes

0 No

various types of joins..

Answer / kumar

Types of joins are :

Equi-Join
Non-Equi-Join
Right Outer Join
Left Outer Join
Full Outer Join
Self Join

Is This Answer Correct ?

1 Yes

0 No

various types of joins..

Answer / shankar

1. Equi Join
2. Non-Equi join
3. Outer Join
4. Self Join

Is This Answer Correct ?

2 Yes

2 No

various types of joins..

Answer / arkchowdary

Joins-------------------- We have
Equi join,
Non-Equi Join,
Outer Join,
Self Join,
Cartesian Join.

Is This Answer Correct ?

1 Yes

1 No

various types of joins..

Answer / anurag

EquiJoin
Non-equijoin
Outer join
Self join

Is This Answer Correct ?

1 Yes

1 No

various types of joins..

Answer / anjum

There are four types of joins

Inner join (Equi join,Non Equi join)
Outer join (Left outer, Right outer,Full outer)
Self join
Cartesian join

Is This Answer Correct ?

0 Yes

0 No

various types of joins..

Answer / vikash kumar gupta

basically three type of join.
inner join,outer join,Cartesian join or product join

Is This Answer Correct ?

0 Yes

0 No

Post New Answer