Re: Looping through column values in a record without specifying

From: DA Morgan <>
Date: Wed, 05 Mar 2008 14:16:21 -0800
Message-ID: <>

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
> 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 (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Wed Mar 05 2008 - 16:16:21 CST

Original text of this message