How about a 100000 row table and doing for all in select * from mytable loop insert commit every time That would be an interesting test. It should be faster in 10g because of automatic bulk inserts, but would show that the same code across different versions is implemented differently. -- //www.freelists.org/webpage/oracle-l