efficienci CURSOR+INSERT vs. INSERT INTO ... SELECT

Hi all,
I have a large amount of data issued from a select to insert into a table Currently, I am doing a loop with a cursor and an inser statement. Looks like:
CURSOR my_cursor is ...;
FOR my_record in my_cursor LOOP

    INSERT INTO ... VALUES (my_record.name, my_record.size, ...); END LOOP; I was wondering if something like INSERT INTO ... SELECT... was not more efficient:
INSERT INTO... SELECT name, size FROM....;

Any ideas ?

Francois Received on Tue Jul 01 2003 - 04:57:54 CDT