Outer Join Examples

Example 1

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

Example 2

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