Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Loop to fill db with dummy data
> DECLARE
> x NUMBER := 0;
> BEGIN
> FOR i IN 1..1000 LOOP
> INSERT INTO performance values(x,'x');
> x := x+1;
That'll only insert 500 records.
> END LOOP;
> END;
> /
Regards,
Knut Received on Mon Apr 08 2002 - 12:55:10 CDT
![]() |
![]() |