select * from
(
select (trunc(sysdate,'mm')+level-1) as dt from dual
connect by rownum<=35
)
where trunc(sysdate,'mm')=trunc(dt,'mm')
select * from
(
select (trunc(sysdate,'mm')+level-1) as dt from dual
connect by rownum<=35
)
where trunc(sysdate,'mm')=trunc(dt,'mm')