Re: Looping through column values in a record without specifying column names?
From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 05 Mar 2008 09:41:34 -0800
Message-ID: <1204738892.763019@bubbleator.drizzle.com>
>
> Thanks Daniel and Thomas. Is there a specific example at:
> http://www.psoug.org/reference/array_processing.html
> which will do what I want?
>
> Tweaked and tried one example and it failed. Many other of the
> examples on the page do a SELECT single_column rather than a SELECT *.
>
> Also, I'm still at 9i R2. So I would need an example that works at
> this release. Most of your examples are classified as 10g or 11i.
>
> Dana
Date: Wed, 05 Mar 2008 09:41:34 -0800
Message-ID: <1204738892.763019@bubbleator.drizzle.com>
dananrg_at_yahoo.com wrote:
>> BULK COLLECT into an array indexed by binary integer and you can do this >> with ease (Morgan's Library atwww.psoug.org).
>
> Thanks Daniel and Thomas. Is there a specific example at:
> http://www.psoug.org/reference/array_processing.html
> which will do what I want?
>
> Tweaked and tried one example and it failed. Many other of the
> examples on the page do a SELECT single_column rather than a SELECT *.
>
> Also, I'm still at 9i R2. So I would need an example that works at
> this release. Most of your examples are classified as 10g or 11i.
>
> Dana
The first "FAST_WAY" example does it ... look at the FOR look between the BULK COLLECT and the FORALL.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Wed Mar 05 2008 - 11:41:34 CST