BULK COLLECT reduces context switches between SQL and PL/SQL engine and allows SQL engine to get many rows at once. More video tutorials http://www.learn-with-video-tutorials.com
Related Videos
Highest Rated Videos
5,433 views2,851 views1,245 views
“We cant see the improvement associated with burrcoperations” is it really that much harder to record a real voice over. Or check for mistakes before release. Do these come in a sexy female voice, that’s the only way I would buy them 😉
There is no need to loop when you are using bulk collection (and not using LIMIT clause).