计算工作日

declare
sdate date;
edate date;
to_day date;
countday number:=0;
today varchar(10);
begin
select to_date(20200117,'yyyymmdd') into edate from dual;
select to_date(20200110,'yyyymmdd') into sdate from dual;
select sdate into to_day from dual;
loop
exit when edate<to_day;
select to_char(to_day,'d') into today from dual;
if today='2' then countday:=countday+1;
elsif today='3' then countday:=countday+1;
elsif today='4' then countday:=countday+1;
elsif today='5' then countday:=countday+1;
elsif today='6' then countday:=countday+1;
--elsif today='6' then countday:=countday+1;
--elsif today='7' then countday:=countday+1;
end if;
dbms_output.put_line(to_day);
dbms_output.put_line(today);
to_day:=to_day+1;
end loop;
dbms_output.put_line(countday);
end;