insert select statement or insert in cursor
651294Jul 22 2008 — edited Jul 22 2008hi all,
i need a performance compare for: insert operation in cursor one by one and select statement insert,
for example:
1. insert into TableA (ColumA,ColumnB) select A, B from TableB;
2. cursor my_cur is select A, B from TableB
for my_rec in my_cur loop
insert into TableA (ColumA,ColumnB) values (my_rec.A, my_rec.B);
end loop;
also "bulk collect into" can be used.
Which one has a better performance?
Thanks for your help,
kadriye