Re: using for loop to read the field values

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 27 Feb 2003 02:13:26 -0800
Message-ID: <a20d28ee.0302270213.4e3f2861_at_posting.google.com>


saroj_vtha_at_yahoo.com (SV) wrote in message news:<bb4abd8a.0302261037.6d07b527_at_posting.google.com>...
> Hello,
> I have an oracle table which has 101 fields in the format:
>
> id val1 val2 val3.............val100
>
> I would like to use the select statement for different ids and print
> the values.
> But instead of manually using the dbms_output.put_line for each of the
> 100 values, is it possible to print it out through a for loop.
> Any suggestion would be appreciated

The best suggestion would be to redesign the datamodel to use array types in your table, or better still normalize the datamodel.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Thu Feb 27 2003 - 11:13:26 CET

Original text of this message