SELECT C2
FROM (SELECT (SELECT C1
FROM (SELECT TO_DATE('20130730', 'yyyy-mm-dd') + LEVEL C1
FROM DUAL
CONNECT BY LEVEL < 8)
WHERE TO_CHAR(C1, 'd') = 1) + LEVEL C2
FROM DUAL
CONNECT BY LEVEL < 8)
FROM (SELECT (SELECT C1
FROM (SELECT TO_DATE('20130730', 'yyyy-mm-dd') + LEVEL C1
FROM DUAL
CONNECT BY LEVEL < 8)
WHERE TO_CHAR(C1, 'd') = 1) + LEVEL C2
FROM DUAL
CONNECT BY LEVEL < 8)