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

2019-11-29 00:42:09 浏览数 (1)

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;

0 人点赞