DISQUS

Website
http://awads.net/wp/
Original page
http://awads.net/wp/2008/11/10/5-recommendations-about-cursor-for-loops-in-oracle-plsql/
Subscribe
All Comments
Community
Top Commenters
- jgarry
  3 comments · 1 points
- Andy C
  22 comments · 47 points
- dahowlett
  1 comment · 2 points
- Don Seiler
  9 comments · 1 points
- davidhaimes
  4 comments · 3 points
Popular Threads

mathewbutler · 1 year ago

Hi Eddie,

The full set of recommendations from Bryn Llewellyn can be found here:

http://www.oracle.com/technology/tech/pl_sql/pd...

Best Regards,
Eddie Awad · 1 year ago

Thanks Mathew. Bryn's white paper is excellent. I linked to it last month from http://awads.net/wp/2008/10/09/4-useful-links-f...
Boneist · 1 year ago

It's worth noting that in 10g, if you're doing step 5, Oracle automatically converts it into step 4 for you (with a default limit of 100).
Eddie Awad · 1 year ago

Yep, and that's good for existing code. There is still however the overhead of converting it to BULK COLLECT. So, the best way is to directly use BULK COLLECT whenever you can.