top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What are various types of joins in Oracle?

+2 votes
What are various types of joins in Oracle?
posted Jan 27, 2015 by Archana

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

Join is a method used to combine two or more tables,views or materialized views based on a common condition. There is wide variety of classification. Below given in one such classification.

Different types of Joins

1. Cross Join/Cartesian Product
2. Natural Join
3. Inner Join
4. Outer join
    a.Left Outer Join
    b.Right Join
    c.Full Outer Join
5. Anti Join
6. Semi Join
7. Self Join
8. Equi Join and Non Equi Join
answer Jan 27, 2015 by Manikandan J