Re: Using UPDATE with ROWNUM?

From: <darrenk_at_yahoo.com>
Date: Tue, 26 Jun 2007 10:56:25 -0700
Message-ID: <1182880585.762336.299440@q69g2000hsb.googlegroups.com>

> But make sure to look up "bulkcollect" and "forall" updating
> examples, which D. Morgan of this same newsgroup recently pointed me
> to! Much higher performance.

TYVM. Useful information for more that just this case!

This post has an example of bulk collect from a sequence (through a dummy table):
http://groups.google.com/group/comp.databases.oracle.server/browse_thread/thread/705c43ab93de187/339fec1f853a5501?lnk=gst&q=bulk+collect&rnum=1#339fec1f853a5501 Is this a reasonably efficient method? I probably want to bulk collect about 1000 values at a time. Received on Tue Jun 26 2007 - 12:56:25 CDT