select level,to_char(to_date('2019-07-01','yyyy-mm-dd')+level-1,'yyyy-mm-dd') as abnormal_date
from dual
connect by level <=to_date('2019-08-01','yyyy-mm-dd')-to_date('2019-07-01','yyyy-mm-dd')+1
select level,to_char(to_date('2019-07-01','yyyy-mm-dd')+level-1,'yyyy-mm-dd') as abnormal_date
from dual
connect by level <=to_date('2019-08-01','yyyy-mm-dd')-to_date('2019-07-01','yyyy-mm-dd')+1