Oracle ETL调度

begin
  for  v_day  in  '20160101'..'20160131' loop
  P_ETL_TWO_STOCK_D(v_day);
  end loop;
end;

DECLARE
  V_DATE VARCHAR2(8);


BEGIN


  FOR V_DATE IN (select the_date ACC_DAY from time_dimension
                  WHERE the_date >= '20160201'
                    AND the_date <= '20160806'
                  GROUP BY the_date
                  ORDER BY the_date) LOOP
  
    P_ETL_TWO_STOCK_D(V_DATE.ACC_DAY);
  
  END LOOP;
END;