display first day of the month between two dates
SELECT TO_CHAR (R_MONTH, 'dd/mm/yyyy') MONTH FROM ( SELECT ADD_MONTHS (TO_DATE ('12-2020', 'mm-yyyy'), ROWNUM - 1) R_MONTH FROM DBA_OBJECTS WHERE ROWNUM <= MONTHS_BETWEEN ( TO_DATE ('01-2021', 'mm-yyyy'), ADD_MONTHS (TO_DATE ('12-2020', 'mm-yyyy'), -1) ) ORDER BY R_MONTH); ------------------------------------------------------ insert...