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

"John" <chunji08 (AT) gmail (DOT) com> a écrit dans le message de news: 4e595876-bcd7-4f57-a0f8-16f59be3f3c4...oglegroups.com...
If the data in the second column does not follow a rule
(maybe the random one) how could you do it in a loop?

If you want to do it in a single statement, have a look at INSERT ALL.

Regards
Michel