Re: Maximum of Columns in one table (9i)

From: Thomas Kellerer <WVIJEVPANEHT_at_spammotel.com>
Date: Wed, 06 Jul 2005 16:25:17 +0200
Message-ID: <3j27ueFnsu6oU1@individual.net>

On 06.07.2005 15:49 Paul wrote:

>>So I could have:
>>person,question_no,response

>
> Nice, neat 3 column table!
>

>>or
>>person,q1response,q2response,....,q200response

>
> OK, at the risk of further exposing my ignorance here, what would be
> the difference (in particular for the sort of query you mention, and
> it's a good example) between having your 201 column table or having a
> table with 1 column which was an array with 201 elements.

Try to query the following information with both solutions and you'll know:

List all persons that answered yes to the first, no the second and yes to the tenth question.

Thomas Received on Wed Jul 06 2005 - 09:25:17 CDT