declare
START_TIME DATE:=TO_DATE( '2021-08-01', 'yyyy-mm-dd');
END_TIME DATE:=TO_DATE( '2021-10-01', 'yyyy-mm-dd');
NOW_DATE_STR VARCHAR2(20);
begin
while START_TIME < END_TIME loop
NOW_DATE_STR :=to_char(START_TIME,'yyyy-mm-dd');
DBMS_OUTPUT.PUT_LINE(NOW_DATE_STR);
START_TIME:= START_TIME + 1;
end loop;
end;
06-30
563