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