What is Oracle Joins ?

• Oracle Joins are used to retrieve data from multiple tables.

• An Oracle JOIN is performed whenever two or more tables are joined in a SQL statement.


Oracle Join Query - Inner Join Query - Left Outer Join Query - Right Outer Join Query - Full Outer Join Query

• There are four different types of Oracle joins:

• Inner Join is the simplest and most common type of join.
• It is also known as simple join.
• It returns all rows from multiple tables where the join condition is met
• It is also called as simple join.

• Left Outer Join returns all rows from the left (first) table specified in the ON condition.
• Only those rows from the right (second) table where the join condition is met.
• It is also called as left join.

• The Right Outer Join returns all rows from the right-hand table specified in the ON condition
• Only those rows from the other table where the join condition is met.
• It is also called as right join.

• The Full Outer Join returns all rows from the left hand table and right hand table.
• It places NULL where the join condition is not met.
• It is also called as full join.