There are 3 types of joins basis on Oracle 8i
Simple join
1. Equi join : Equi join is one which contains comparision operator '=' in where clause.
2. Non Equi join: If the comparision operator in the join condition is other than '=' then it is ....
Self join : Joining a table to itself can be done by..
Outer join : To retrieve rows which do not satisfy a query, the outer join concept can be used.