|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
DO NOT ask technical questions here! They will be deleted!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!