获取季度

select to_char(add_months(add_months(trunc(sysdate-1, 'yyyy'),a * 3),-rownum),'yyyy-mm') last_q from (select to_char(sysdate-1,'q') a from dual) connect by rownum <= 3 order by 1;