with item_type as 
( select 101 item_id,'component1' name,1 type from dual
  union all
  select 201 item_id,'component2' name,1 type from dual
  union all
  select 301 item_id,'component3' name,2 type from dual
  union all
  select 401 item_id,'component4' name,2 type from dual
  union all
  select 501 item_id,'component5' name,3 type from dual)
  select * from item_type
  
  with item_values as
  (
  select 1 id,'One' value,101 item_id from dual
  union all
  select 2 id,'Two' value,101 item_id from dual
  union all
  select 3 id,'Three' value,101 item_id from dual
  union all
  select 4 id,'Day1' value,201 item_id from dual
  union all
  select 5 id,'Day2' value,201 item_id from dual
  union all
  select 6 id,'Yes' value,301 item_id from dual
  union all
  select 7 id,'No' value,301 item_id from dual
  union all
  select 8 id,'Others' value,301 item_id from dual
  union all
  select 9 id,'Demo' value,501 item_id from dual
  union all
  select 10 id,'Real' value,501 item_id from dual
  )
  select * from item_values

 Item_ID   |  Name           |  Value
  
  101         Component1      One,Two,Three
  201         Component2      Day1,Day2
  301         Component3      Yes,No,Others
  501         Component5      Demo,Real

SQL> with item_type as 
  2  ( select 101 item_id,'component1' name,1 type from dual
  3    union all
  4    select 201 item_id,'component2' name,1 type from dual
  5    union all
  6    select 301 item_id,'component3' name,2 type from dual
  7    union all
  8    select 401 item_id,'component4' name,2 type from dual
  9    union all
 10    select 501 item_id,'component5' name,3 type from dual),
 11  item_values as
 12    (
 13    select 1 id,'One' value,101 item_id from dual
 14    union all
 15    select 2 id,'Two' value,101 item_id from dual
 16    union all
 17    select 3 id,'Three' value,101 item_id from dual
 18    union all
 19    select 4 id,'Day1' value,201 item_id from dual
 20    union all
 21    select 5 id,'Day2' value,201 item_id from dual
 22    union all
 23    select 6 id,'Yes' value,301 item_id from dual
 24    union all
 25    select 7 id,'No' value,301 item_id from dual
 26    union all
 27    select 8 id,'Others' value,301 item_id from dual
 28    union all
 29    select 9 id,'Demo' value,501 item_id from dual
 30    union all
 31    select 10 id,'Real' value,501 item_id from dual
 32    ),
 33  item_values_bis as (
 34    select id, value, item_id,
 35           row_number() over (partition by item_id order by id) rn
 36    from item_values
 37    ),
 38  item_values_ter as (
 39    select item_id,
 40           sys_connect_by_path(value,',') vals
 41    from item_values_bis 
 42    where connect_by_isleaf = 1
 43    connect by prior item_id = item_id and prior rn = rn-1
 44    start with rn = 1
 45    )
 46  select t.item_id, t.name, substr(v.vals,2) vals
 47  from item_type t, item_values_ter v
 48  where v.item_id = t.item_id
 49  order by item_id
 50  /
   ITEM_ID NAME       VALS
---------- ---------- --------------------------------------------------
       101 component1 One,Two,Three
       201 component2 Day1,Day2
       301 component3 Yes,No,Others
       501 component5 Demo,Real