Re: Looping through column values in a record without specifying column names?

From: DA Morgan <>
Date: Wed, 05 Mar 2008 09:41:34 -0800
Message-ID: <> wrote:

>> BULK COLLECT into an array indexed by binary integer and you can do this
>> with ease (Morgan's Library

> Thanks Daniel and Thomas. Is there a specific example at:
> 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 (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Wed Mar 05 2008 - 11:41:34 CST

Original text of this message