OracleVillage

SELECT
(TO_DATE('2007-01-01', 'YYYY-MM-DD') + (ROWNUM - 1) * 7) FromDate,
TO_CHAR((TO_DATE('2007-01-01', 'YYYY-MM-DD') + (ROWNUM - 1) * 7),'MM') Mth,
ROWNUM CHECK_PERIOD
FROM DUAL
CONNECT BY
LEVEL <=&no
/

When we execute the above sql query, it will prompt us to enter a number. Say we entered 4. We will get the following output from the query.

FROMDATE MTH CHECK_PERIOD
--------- --- ------------
01-JAN-07 01 1
08-JAN-07 01 2
15-JAN-07 01 3
22-JAN-07 01 4


4 rows selected.

Cheers,
Sonam J