saravanakumar, March 25, 2021 - 10:00 am UTC
with df as(select rownum+trunc(to_date(sysdate),'year')-1 all_date from dual
connect by level<366),
fd as (select all_date ,to_char(all_date,'fmday') lk from df),
wq as (select rownum rm ,all_date,lk from fd where lk='wednesday')
select all_date,lk from wq where mod(rm,2)=1;