Comments
| 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? Thanks, Bill Example: SELECT * BULK COLLECT INTO l_table LIMIT 1000 FROM testing_table t WHERE t.col20 = 'Valid'; |
Bill said... Ignore that last question....that's for the forums!!! Sorry! Bill |
karthik said... It was very valuable articleThanks |
suman said... Nice |
DO NOT ask technical questions here, that's what my forum is for!
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!