oracle 初始化自然日 周六周日表示符号

declare i number; begin for i in 36..400 Loop insert into table(workdate,isholodayflg)values(to_char(sysdate+i,'YYYYMMdd'), case when to_char(sysdate+i,'d') in ('1','7') then 1 else 0 end ); end loop; end;