DECLARE
x NUMBER := 0;
BEGIN
FOR i IN 1..1000 LOOP
INSERT INTO performance values(x,'x');
x := x+1;
END LOOP;
END;
/
cot_r wrote:
>
> Hi, thx for reading this.
>
> 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)
>
> thx
>
> --
> Outgoing mail is certified Virus Free. NAV
> HomePage: freesco_ linux router
> http://users.pandora.be/vanespen
Received on Mon Apr 08 2002 - 11:58:26 CDT
