Re: Looping through column values in a record without specifying

Malcolm Dew-Jones wrote:

> : Cursor loops such as in your example have been obsolete since the
> : introduction of Oracle 9i.
>
> : BULK COLLECT into an array indexed by binary integer and you can do this
> : with ease (Morgan's Library at www.psoug.org).
>
> I am not sure how BULK COLLECT will help him to print out the individual
> columns without knowing the name of each column.

You don't need to know the column names ... just look through the indices of the array.

-- 
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.org