Re: 8i max columns

Of course not that would be ridiculous. You have a single table with a WHERE clause accessed using the LIKE or IN or EXISTS operator.

Questionnaire_no field can hold an infinite number of questionnaires and the Question_no field an infinite number of questions. Why would you need 17 tables for 17 responses? One table with three columns handles it all.

Daniel A. Morgan

Jonathan Lewis wrote:

> But if you want to select candidates according
> to 17 different responses, then you have a
> seventeen table join - which isn't too great.
> And, of course, your total storage size is
> massive compared to a 1-row = 1 paper solution.
>
> --
> 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 <3ACC18EA.5C5881CA_at_exesolutions.com>...
> >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.
> >>
Received on Fri Apr 06 2001 - 00:24:48 CDT