Re: Multi Rows String concatenation

From: Dave Hau <davehau-no-spam-123_at_no-spam.netscape.net>
Date: Sat, 24 May 2003 15:50:19 GMT
Message-ID: <%wMza.2516$5q5.66864326@newssvr21.news.prodigy.com>

In 9i, you can use a user-defined aggregate. Otherwise if you're using 8i, use the function provided by Tom. Read the details here:

http://asktom.oracle.com/pls/ask/f?p=4950:8:211536505335030432::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:2200571416651,

Cheers,
Dave

"Catalin Trifu" <catalin_at_isp-software.de> wrote in message news:d0b5fe87.0305240450.77461fd4_at_posting.google.com...
> Hi,
>
> I want to concatenate the values from a VARCHAR2 type column based
> on a
> GROUP BY clause.
> I know there are no aggregate functions for such a thing, and I was
> wondering how to achieve this.
> Example:
>
> tables CUSTOMERS(id_customer, str_name)
> PRODUCTS(id_product, str_number)
> CONTRACTS(id_contract, str_number)
> CONTRACTS_PRODUCT(id_contract_product, id_contract,
> id_customer, id_product)
>
> I want to get all the contract numbers for the customer, product
> combinations in one SELECT query and so far I was very much
> unsuccessfull.
> Any help would be really appreciated.
>
> Thanks,
> Catalin
Received on Sat May 24 2003 - 10:50:19 CDT