select to_char(sysdate,'yyyymm') yearmonth from dual
union
select to_char(add_months(sysdate,-1),'yyyymm') from dual
union
select to_char(add_months(sysdate,-2),'yyyymm') from dual
union
select to_char(add_months(sysdate,-3),'yyyymm') from dual
----------------------------------------------------------
YEARMONTH
1 200712
2 200801
3 200802
4 200803