Re: 8i max columns

I'm glad you asked. Still the wrong solution. The correct solution is:

Questionnaire_no NUMBER(3),

Question_no           NUMBER(3),
Answer_value         CHAR(1)

or something like that. Think vertically not horizontally. The above table would hold an unlimited number of questionnaires with an unlimited number of questions. That some something impossible to handle if you try it the other way.

Daniel A. Morgan

Jonathan Lewis wrote:

> How about a multi-choice questionnaire with
> 100 (or 300) questions, and a group of market
> researchers who want to ask for completely
> arbitrary results - you MIGHT set this up as
> a wide table with bitmap indexes on every column.
>
> --
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Practical Oracle 8i: Building Efficient Databases
> Publishers: Addison-Wesley
>
> Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
>
> Daniel A. Morgan wrote in message <3ACA4541.80BFFEBC_at_exesolutions.com>...
> >
> >There is no rational reason to define a table with 256 or more columns. In
> >fact I would be seriously concerned about any table with 25 or more columns
> >in a normalized database.
  Received on Thu Apr 05 2001 - 02:04:11 CDT