Oracle 12c Join Conditions and Join Types

Here I am describing below the Oracle 12c join conditions and join types that allow you to create more advance queries. There are two types of join conditions, which are based on the operator and three types of join types.

Join Conditions

  1. Equijoins: uses the equality operator in queries.
  2. Non-equijoins: uses the operator Between, Like and so on, instead of equality operator e.g. <, >, =.

Join Types

  1. Inner joins: returns a row only when the fields in the join contain values that matches the join condition. Means if values are not equal of join columns then row isn't returned.
  2. Outer joins: returns a row even when one of the fields in the join condition contains a null value.
  3. Self joins: returns a row joined on the same table.

You can find the examples of SQL joins in the following post Oracle SQL Joins. You can also refer Oracle Documentation for the same.

 

Vinish Kapoor

An Oracle Apex Consultant, Oracle ACE, and founder of foxinfotech.in and orclqa.com a question and answer forum for developers.