how to make a loop to do an insert for varchars

From: John <chunji08_at_gmail.com>
Date: Tue, 12 Oct 2010 16:49:33 -0700 (PDT)
Message-ID: <4e595876-bcd7-4f57-a0f8-16f59be3f3c4_at_g18g2000yqk.googlegroups.com>

Hi folks,
let's say I want to do an insert of multiple rows, such as
"

insert into table ( id, column1 ) valuess ( idseq.nextval, 'abc');
insert into table ( id, column1 ) valuess ( idseq.nextval, 'jfk');
insert into table ( id, column1 ) valuess ( idseq.nextval, 'efg');
insert into table ( id, column1 ) valuess ( idseq.nextval, 'bbc');
insert into table ( id, column1 ) valuess ( idseq.nextval, 'bbb');
insert into table ( id, column1 ) valuess ( idseq.nextval, 'xyz');

...
"

Is there a way I can do that in a for loop in oracle sql ?

Thanks for the tips.

John Received on Tue Oct 12 2010 - 18:49:33 CDT