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