|Bulk Binds - Improve performance by reducing the overhead associated with context switches between the PL/SQL and SQL engines.|
Mark said...Excellent. Been back here about 20 times for reference.
Jaggy said...Excellent stuff here. I am learning PL/SQL from this site and there is lotsa stuff to learn here ...
Deps said...Wonderful!!!!! Im doing a project on migration from flat file to oracle. If u can give more tips on vill be of great help.
Parimal said...Excellent... explaination with simple example
Bill said...Great article!
I've also read that "nested tables" should be used with a "limit" clause - 1000 is a recommeded upper limit.
Does that apply only to SELECT INTO.... statements?
BULK COLLECT INTO l_table LIMIT 1000
FROM testing_table t
WHERE t.col20 = 'Valid';
Ignore that last question....that's for the forums!!! Sorry!
karthik said...It was very valuable article