Oracle Tutorial

Right Outer Join Examples

Example 1

Select cd.customer_id, cd.email,
u.user_id, u.full_name
From users u
RIGHT OUTER JOIN customers_details cd
ON u.user_id = cd.user_id
Where u.department_name = 'SALES'
Order By cd.customer_id

Example 2

Select cd.customer_id, cd.email,
u.user_id, u.full_name
From users u,
customers_details cd
Where cd.user_id = u.user_id (+)
Order By cd.customer_id