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: Knut Talman <knut.talman_at_mytoys.de>
Date: Mon, 08 Apr 2002 19:55:10 +0200
Message-ID: <3CB1D97D.7D72AA90@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.

> END LOOP;
> END;
> /

Regards,

Knut Received on Mon Apr 08 2002 - 12:55:10 CDT

Original text of this message

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