Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Loop to fill db with dummy data
> 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