select * from (SELECT INST_CODE
from DC_R_MEDICAL_INSTITUTION_BASE
where HEALTH_INST_TYPE_CODE in ('A100','B100','D600')),
(select
to_char(trunc(to_date('2018/11/13','yyyy/MM/dd') -15 + Rownum,'dd'), 'yyyy/MM/dd') as monthlist
from dual
connect by rownum <= 6 )
order by monthlist