oracle中传入number类型日期加一天的处理

如下为日期循环加一天

declare
    v_new_day number(8);
begin
    v_new_day := 20180729;
    loop
        select to_number(to_char(to_date(to_char(v_new_day), 'yyyymmdd') + 
 1,'yyyymmdd')) into v_new_day from dual;
        dbms_output.put_line(v_new_day);
        exit when v_new_day >= 20180805;
    end loop;
end;

结果如下：