Oracle Tutorial

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 (+)