Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Column aggregating for text columns

Re: Column aggregating for text columns

From: Tokunaga T. <tonkuma_at_jp.ibm.com>
Date: 23 May 2002 22:21:26 -0700
Message-ID: <8156d9ae.0205232121.87d97a1@posting.google.com>


svenigalla_at_netsetgo.com (Srini Venigalla) wrote in message news:<22597f96.0205231116.4a741078_at_posting.google.com>...
> Continuing my previous post:
>
> Will the query still work, if you had more than 3 rows per ID. Some thing like:
>
> 123 A
> 123 B
> 123 C
> 123 D
> 222 A
> 222 B
> 333 K
> 333 L
> 333 M
> 333 N
>
> .. so on

I want to re-ask you my first question. That was.

> My question is how to map value 'abc' to column value1, value 'cde' to
> column value2 and value 'xxx' to column value3.
> If you could clarify that point, it would be not so difficult to solve
> this problem.

How to map K, L, M, N ... to columns value1, value2 and value3? There are too many values to put in only three columns. Received on Fri May 24 2002 - 00:21:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US