how to check leap-year

[kris123]

sorry...i already removed the "rem"

update apec_stat_rpt set bid_clr=(select nvl(count(*),0) from apec where bid_permission='YES'
and to_date(substr(BID_REPLY,1,11),'dd/Mon/yyyy')=to_date('01/&month1/&year1','dd/MON/yyyy')+i)
where date1=i+1 ;