Posted by DA Morgan on 04/16/07 21:33

Alex wrote:
> Hi Expert,
> In my DB i have a big table like this:
>
> Primary key | param1 | para2 | param3 | param4 | ... | param100|
> ------------------+-----------+---------+-----------+------------+----
> +--------------+
> | | | |
> | | |
>

Then I would suggest you stop writing DML and fix the problem:

Primary Key | Parameter ID | Parameter Value

Your report writers, no doubt, will want to draw blood for such
an abominable lack of design.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

[Back to original message]