Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Loop to fill db with dummy data

Re: Loop to fill db with dummy data

From: JonINJoy <jon.yi_at_verizon.net>
Date: Mon, 08 Apr 2002 18:33:09 GMT
Message-ID: <Fnls8.6223$F13.2491@nwrddc03.gnilink.net>

Knut Talman <knut.talman_at_mytoys.de> wrote in message news:3CB1D97D.7D72AA90_at_mytoys.de...
> > 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.

Yes, it adds 1000 records.
verified.
>
> > END LOOP;
> > END;
> > /
>
> Regards,
>
> Knut
Received on Mon Apr 08 2002 - 13:33:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US