Oracle Outer Join

The Oracle Outer Join returns all rows that match the join condition (inner join) and also returns rows of a left and right outer join.

Oracle Outer Join example

Select 
c.customer_id, c.name, cd.email, cd.phone
From customers c, 
customers_details cd
Where cd.customer_id (+) = c.customer_id

Select 
c.customer_id, c.name, cd.email, cd.phone
From customers c, 
customers_details cd
Where cd.customer_id = c.customer_id (+)