Show the Start Date and End Date of the Month

--
-- Show the Start Date and End Date of the Month
--
 
SET PAUSE ON
SET PAUSE 'Press return to Continue'
SET LINESIZE 300
SET PAGESIZE 60
 
SELECT 
  ADD_MONTHS (TRUNC (SYSDATE, 'MONTH'), i) start_date,
  TRUNC (LAST_DAY (ADD_MONTHS (SYSDATE, i))) end_date
FROM XMLTABLE 
  ('for $i in 0 to xs:int(D) return $i'PASSING XMLELEMENT (d,FLOOR (MONTHS_BETWEEN (ADD_MONTHS (TRUNC (SYSDATE, 'YEAR') - 1, 12),SYSDATE)))COLUMNS i INTEGER PATH '.')
/

---

Published 1st January 2022