Oracle 11g Release 2

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

CREATE TABLE table_name (id, start_date, end_date) AS
SELECT 44, DATE '2020-01-04', DATE '2020-01-04' FROM DUAL UNION ALL
SELECT 44, DATE '2020-01-30', DATE '2020-02-10' FROM DUAL UNION ALL
SELECT 44, DATE '2020-02-27', DATE '2020-03-03' FROM DUAL;
3 rows affected

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
WITH months ( id, start_date, end_date, final_date ) AS (
  SELECT id,
         start_date,
         LEAST( LAST_DAY( start_date ), end_date ),
         end_date
  FROM   table_name
UNION ALL
  SELECT id,
         end_date + INTERVAL '1' DAY,
         LEAST( ADD_MONTHS( end_date, 1 ), final_date ),
         final_date
  FROM   months
  WHERE  end_date < final_date
)
SEARCH DEPTH FIRST BY final_date SET dt_order
SELECT id,
       start_date,
       end_date
FROM   months;


ID
START_DATE
END_DATE


44
2020-01-04 00:00:00
2020-01-04 00:00:00

44
2020-01-30 00:00:00
2020-01-31 00:00:00

44
2020-02-01 00:00:00
2020-02-10 00:00:00

44
2020-02-27 00:00:00
2020-02-29 00:00:00

44
2020-03-01 00:00:00
2020-03-03 00:00:00

ID	START_DATE	END_DATE
44	2020-01-04 00:00:00	2020-01-04 00:00:00
44	2020-01-30 00:00:00	2020-01-31 00:00:00
44	2020-02-01 00:00:00	2020-02-10 00:00:00
44	2020-02-27 00:00:00	2020-02-29 00:00:00
44	2020-03-01 00:00:00	2020-03-03 00:00:00