1  select to_char(add_months(to_date('31.01.2020', 'dd.mm.yyyy') ,level-1),'mm.yyyy') m from dual
  2* connect by add_months(to_date('31.01.2020', 'dd.mm.yyyy') ,level-1)<= last_day(to_date('17.04.2020', 'dd.mm.yyyy'))
SQL> /

M
-------
01.2020
02.2020
03.2020
04.2020

SQL> ed
Wrote file afiedt.buf

  1  select *
  2     from (select deptno,sal,to_char(hiredate,'mm')+0 mm from emp)
  3*   pivot (sum(sal) for mm in (1,2,3,4,5,6,7,8,9,10,11,12))
SQL> /

    DEPTNO          1          2          3          4          5          6          7          8          9         10         11         12
---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
        30                  2850                             2850                                        2750                              950
        20       1100                             2975                                                                                    6800
        10       1300                                                   2450                                                   5000

SQ

SQL> ed
Wrote file afiedt.buf

  1  with w1 as  -- так примерно выглядят селекты к данным, данные выбираются по имени строки - rown и дате -dater, то есть строк в выборке может быть много, мне нужно выбрать перечнь конкретных, данные в выборке есть за все 12 месяцев каждого года
  2  (
  3  select '123' as rown, 10 as value, to_date('31.01.2020', 'dd.mm.yyyy') as dater, '11' as id from dual
  4  union all
  5  select '124' as rown, 20 as value, to_date('31.01.2020', 'dd.mm.yyyy') as dater, '12' as id from dual
  6  union all
  7  select '125' as rown, 50 as value, to_date('29.02.2020', 'dd.mm.yyyy') as dater, '13' as id from dual
  8  union all
  9  select '123' as rown, 50 as value, to_date('31.03.2020', 'dd.mm.yyyy') as dater, '13' as id from dual
 10  union all
 11  select '124' as rown, 60 as value, to_date('31.03.2020', 'dd.mm.yyyy') as dater, '14' as id from dual
 12  )
 13  ,w2 as (select rown,value,id,to_char(dater,'mm') mm from w1 w1 where dater>=to_date('31.01.2020', 'dd.mm.yyyy') and dater<=to_date('31.03.2020', 'dd.mm.yyyy'))
 14  select
 15    decode(grouping_id(ROWN),1,(listagg(rown,',') WITHIN GROUP (ORDER BY rown ) ),rown) r
 16  ,decode(grouping_id(ROWN),1,sum(M1_S_VAL),M1_S_VAL) M1_S_VAL
 17  ,decode(grouping_id(ROWN),1,null+0,M1_S_ID) M1_S_ID
 18  --
 19  ,decode(grouping_id(ROWN),1,sum(M2_S_VAL),M2_S_VAL) M2_S_VAL
 20  ,decode(grouping_id(ROWN),1,null+0,M2_S_ID) M2_S_ID
 21  --
 22  ,decode(grouping_id(ROWN),1,sum(M3_S_VAL),M3_S_VAL) M3_S_VAL
 23  ,decode(grouping_id(ROWN),1,null+0,M3_S_ID) M3_S_ID
 24  -- ...
 25  ,decode(grouping_id(ROWN),1,sum(M12_S_VAL),M12_S_VAL) M12_S_VAL
 26  ,decode(grouping_id(ROWN),1,null+0,M12_S_ID) M12_S_ID
 27  from w2 w2 pivot (sum(value) as s_val, sum(id) as s_id for mm in ('01' as m1,'02' as m2,'03' as m3,/*...*/'12' as m12))
 28* group by grouping sets ((ROWN,M1_S_VAL,M1_S_ID,M2_S_VAL,M2_S_ID,M3_S_VAL ,M3_S_ID,M12_S_VAL ,M12_S_ID),())
SQL> /

R                 M1_S_VAL    M1_S_ID   M2_S_VAL    M2_S_ID   M3_S_VAL    M3_S_ID  M12_S_VAL   M12_S_ID
--------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
123                     10         11                               50         13
124                     20         12                               60         14
125                                           50         13
123,124,125             30                    50                   110

SQL>