with t as (select date'2016-7-1'+level-1 as dt from dual connect by level<=365)
select distinct to_char(dt,'iw') as iw from t where t.dt between trunc(to_date('2016-07-12 11:07:38','yyyy-MM-dd hh24:mi:ss')) and
trunc(to_date('2016-07-12 11:07:38','yyyy-MM-dd hh24:mi:ss')) and
to_char(t.dt,'yyyy/MM') = '2016'||'/'||'07' order by to_char(dt,'iw')
select distinct to_char(dt,'iw') as iw from t where t.dt between trunc(to_date('2016-07-12 11:07:38','yyyy-MM-dd hh24:mi:ss')) and
trunc(to_date('2016-07-12 11:07:38','yyyy-MM-dd hh24:mi:ss')) and
to_char(t.dt,'yyyy/MM') = '2016'||'/'||'07' order by to_char(dt,'iw')