Oracle Right Outer Join

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

Oracle Right Outer Join example

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;

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;