sql> ed
Wrote file afiedt.buf

    select to_char( add_months( start_date,level-1 ),'fmMonth' )
      from (select date '2011-03-30' start_date,date '2011-06-29' end_date
              from dual)
     connect by level <= months_between(
                           trunc(end_date,'MM'),trunc(start_date,'MM') )
  *                      + 1
sql> /

TO_CHAR(ADD_MONTHS(START_DATE,LEVEL-
------------------------------------
March
April
May
June

应该管用.