Oracle PL/SQL Case Example

Select o.id, u.name,
CASE
	WHEN o.id = '1' THEN 'SALES'
	WHEN o.id = '2' THEN 'SALES'
	WHEN o.id = '3' THEN 'SALES'
	ELSE 'MANAGER'  
END
From offers o, users u
Where o.user_code = u.user_code ;