Oracle PL/SQL Outer Join

Outer Join is the select query of two different tables filling one relationship with NULL values, there where is no value that satisfies the condition of matching.

Outer Example:

Select e.ename, d.dname,d.loc
From emp e, dept d
Where e.deptno(+) = d.deptno;

Left Join Example:

Select *
From emp e LEFT OUTER JOIN dept d
ON e.deptno = d.deptno;

Right Join Example:

Select *
From emp e RIGHT OUTER JOIN dept d
ON e.deptno = d.deptno;