4.3 Types of Join in Oracle A join type is determined by the type of join condition. Oracle provides the following types of join based on the condition written. Equi join Non-equi join Self Join Outer Join Doc navigation← 4.2 Cartesian Product4.4 Equi Join → Was this article helpful to you? Yes No How can we help? Name Email subject message