Re: Multi Rows String concatenation

From: Dave Hau <davehau-no-spam-123_at_no-spam.netscape.net>
Date: Sat, 24 May 2003 15:52:40 GMT
Message-ID: <czMza.2517$5q5.66864326@newssvr21.news.prodigy.com>

A related article for concatenation:

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

Cheers,
Dave

"Dave Hau" <davehau-no-spam-123_at_no-spam.netscape.net> wrote in message news:%wMza.2516$5q5.66864326_at_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:52:40 CDT