Re: Loop to fill db with dummy data

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

insert into performance
select rownum,'x'
from any_existing_table_with_1000_records_or_more where rownum < 1000

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."