In Oracle forms, how to get the Second Monday of every month in a given date range?
I've tried below query using WITH Clause, but looks like WITH Clause doesn't work in Oracle forms. So is there any other way to do this in Oracle forms?
WITH month_range AS
(
SELECT TO_DATE ('Dec 2013', 'Mon YYYY') AS first_month
, TO_DATE ('Mar 2014', 'Mon YYYY') AS last_month
FROM dual
)
SELECT NEXT_DAY ( 6 + ADD_MONTHS ( first_month
, LEVEL - 1
)
, 'MONDAY'
) AS second_monday
FROM month_range
CONNECT BY LEVEL <= 1 + MONTHS_BETWEEN (last_month, first_month)
;
Thanks in Advance.