1  with names
  2    as (  select 'name1' as n, 1 as n_id from dual
  3          union all
  4          select 'name2' as n, 2 as n_id from dual
  5          union all
  6          select 'name3' as n, 3 as n_id from dual
  7          union all
  8          select 'name4' as n, 4 as n_id from dual
  9          union all
 10          select 'name5' as n, 5 as n_id from dual
 11          union all
 12          select 'name6' as n, 6 as n_id from dual
 13       ),
 14  notes
 15    as (  select 1 as n_id, 'color1' as r_id from dual
 16          union all
 17          select 1 as n_id, 'color2' as r_id from dual
 18          union all
 19          select 1 as n_id, 'color3' as r_id from dual
 20          union all
 21          select 2 as n_id, 'color4' as r_id from dual
 22          union all
 23          select 3 as n_id, 'color5' as r_id from dual
 24          union all
 25          select 3 as n_id, 'color6' as r_id from dual
 26       )
 27  select nn.n,nt.r_id
 28  ,lag('',1,nn.n) over (partition by nn.n order by r_id) nn
 29  from names nn
 30  join notes nt on nt.n_id=nn.n_id
 31* order by n,r_id,nn nulls last
SQL> /

N     R_ID   NN
----- ------ -----
name1 color1 name1
name1 color2
name1 color3
name2 color4 name2
name3 color5 name3
name3 color6

6 rows selected.