|
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
Navigation:
[Reply to this message]
|