Joins in Oracle

1. The purpose of a join is to combine the data across tables.

2. A join is actually performed by the where clause which combines the specified rows of tables.

3. If a join involves in more than two tables then Oracle joins first two tables based on the joins condition and then compares the result with the next table and so on.

TYPES

1     Equi join

2     Non-equi join

3     Self join

4     Natural join

5     Cross join

6     Outer join 

              Left outer 

              Right outer 

              Full outer 

7     Inner join

8     Using clause

9     On clause