Oracle Left Outer Join

The Oracle Left Outer Join is a query that performs an outer join of tables A and B and returns all rows from A.

Oracle Left Outer Join example

Select 
c.customer_id, c.name, 
cd.email, cd.phone
From customers c  
LEFT OUTER JOIN customers_details cd
ON cd.customer_id = c.customer_id
Where c.customer_id > 3500
Order By 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
Order By c.customer_id;