Oracle PL/SQL joins are a way to combine data from multiple tables into a single result set. Below are a list of pl/sql joins that you can use to learn some basic rules about joins.
INNER JOIN
Inner Join – The most common type of join is the inner join, which returns only rows that match in both tables.
LEFT JOIN
Left Join – Left and right joins are variations on the inner join. A left join returns all rows from the left table, even if there are no matches in the right table.
RIGHT JOIN
Right Join – A right join returns all rows from the right table, even if there are no matches in the left table.
SELF JOIN
Self Join – Self joins are a type of join that joins a table to itself. This can be useful when you need to compare data in a single table, such as finding employees who have the same job title.
FULL JOIN
Full Join – Full joins return all rows from both tables, even if there are no matches in either table. This can be useful when you want to see which values in one table are not present in another table.