Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

with products( id, name ) as
(
 select 1,'cars'  from dual union all
 select 2,'bike'  from dual union all
 select 3,'van'   from dual union all
 select 4,'jeep'  from dual union all 
 select 5,'lorry' from dual union all
 select 6,'cab'   from dual union all
 select 7,'bus'   from dual 
), customers( id, name ) as
(
 select 1,'john'  from dual union all
 select 2,'smith' from dual union all
 select 3,'shane' from dual union all
 select 4,'mark'  from dual 
), sells( id, product_id, customer_id ) as
(
 select  1,1,1 from dual union all
 select  2,2,2 from dual union all
 select  3,3,4 from dual union all
 select  4,4,1 from dual union all 
 select  5,4,4 from dual union all
 select  6,5,4 from dual union all
 select  7,6,3 from dual union all
 select  8,6,4 from dual union all
 select  9,7,1 from dual union all
 select 10,7,3 from dual union all
 select 11,7,4 from dual 
)
select c.name as "name", 
       max(case when s.product_id = 1 then '*' end) as "cars",
       max(case when s.product_id = 2 then '*' end) as "bike",
       max(case when s.product_id = 3 then '*' end) as "van",
       max(case when s.product_id = 4 then '*' end) as "jeep",       
       max(case when s.product_id = 5 then '*' end) as "lorry",       
       max(case when s.product_id = 6 then '*' end) as "cab",       
       max(case when s.product_id = 7 then '*' end) as "bus"       
  from sells s
  left join customers c on c.id = s.customer_id  
  group by c.id, c.name 
  order by c.id;

name	cars	bike	van	jeep	lorry	cab	bus
john	*	null	null	*	null	null	*
smith	null	*	null	null	null	null	null
shane	null	null	null	null	null	*	*
mark	null	null	*	*	*	*	*