听起来你想要这样的东西
SQL> edWrote file afiedt.buf 1 select to_char( add_months(trunc(sysdate,'MM'),-1) + level - 1, 2 'YYYYMMDD' ) 3 from dual 4 connect by level <= 5 last_day(add_months(trunc(sysdate,'MM'),-1)) - 6 add_months(trunc(sysdate,'MM'),-1) + 7* 1SQL> /TO_CHAr(--------2010120120101202201012032010120420101205201012062010120720101208201012092010121020101211201012122010121320101214201012152010121620101217201012182010121920101220201012212010122220101223201012242010122520101226201012272010122820101229201012302010123131 rows selected.
