declare

  total date:=  trunc(sysdate-1) ;

  begin

  for i_count in 1..10000 LOOP

   insert into DQ_DATE(date_time)  values (  total );

  total := total + 1/24;

  end loop;

end;