Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
SELECT
TRUNC(SYSDATE, 'MM') + LEVEL - 1 AS calendar_date
FROM
dual
CONNECT BY
TRUNC(SYSDATE, 'MM') + LEVEL - 1 <= LAST_DAY(SYSDATE);