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 18:56:09 +0200
Message-ID: <3CB1CBA9.4D65F007@mytoys.de>


> Hi, thx for reading this.

Don't mention it.

> I have a simple table called performance( ID numeber, Name Varchar) for
> testing purposes.
>
> How can i fill this table with "dummy" data. I want to insert a 1000 records
> (id 0-1000) and name='x'.?
>
> How do i write a loop in SQLplus for this? ( or with somthing else)

declare
 i number;
begin
 for i in 1..1000 loop
   insert into performance values (i, 'x');  end loop;
 commit;
end;
/

HTH, Knut Received on Mon Apr 08 2002 - 11:56:09 CDT

Original text of this message

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