This explains how to perform a series of date functions on rows using the SELECT statement applied to a table with SQL Server Oracle Developer connected to an Oracle database version 18c.
SYSDATE
MONTHS_BETWEEN
NEXT_DAY
ADD_MONTHS
LAST_DAY
ROUND
TRUNC