List the next 30 days dates

[ijswalker]

I am using a passthrough query that queries an Oracle Database and I want to be able to have a list of the next 30 days dates. Does anyone know how to do this. I have an SQL query for listing the same day for the next few months but am struggling to get it to days. See below.

SELECT TO_CHAR (
  NEXT_DAY (
    LAST_DAY (
        ADD_MONTHS (TRUNC(SYSDATE,'Y'),ROWNUM-1))-7,
        TO_CHAR (TO_DATE('29-01-1927', 'DD-MM-YYYY'),'DAY')
  ), 'DD.MM.YYYY') "Last Saturdays in 2004"
 FROM ALL_OBJECTS
WHERE ROWNUM <= 12;

Can anyone help?

Thanks

Ian

 

[ijswalker]

After further research the answer is below. This will work in a passthrough query, querying an Oracle database.

Very useful.

Cheers

Ian

SELECT 
TO_DATE('2010-01-01','YYYY-MM-DD') + ((LEVEL - 1) * 1) start_dt
, LEAST(TO_DATE('2010-01-01','YYYY-MM-DD') + ((LEVEL - 1) * 1) + 9
, TO_DATE('2010-02-20','YYYY-MM-DD')) end_dt  
FROM DUAL  
CONNECT BY TO_DATE('2010-01-01','YYYY-MM-DD') + ((LEVEL - 1) * 1)  <= TO_DATE('2010-02-20','YYYY-MM-DD')