How can I get a select of 12 month starting with current month down

[borisch]

How can I get a select of 12 month starting with current month down. Example 06/2002, 05/2002,..........08/2001,07/2001
Please help
Thanks for your help

 

[njtornado]

Not exactly your answer...but seems to be similar...

We run a canned report for a "rolling" last 7 days using trunc(sysdate)-7 as the earliest date and trunc(sysdate) as the latest date.

Sysdate is the system date selected from the "default" dual table that comes with Oracle.
Trunc() gives us a flat date so the date is inclusive of all hours/minutes within that day.
-7 goes 7 days back from the sysdate.

 

[lewisp]

SELECT To_Char(Add_Months(SYSDATE,-ROWNUM + 1),'MM/YYYY')
FROM a_table
WHERE ROWNUM <= 12

a_table should be a table, such as DICT, that you can be sure has more than 12 rows in it.