Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Multi Rows String concatenation
"Antoine BRUNEL" <antoinebrunel/yahoo.fr (remove / )> wrote in message news:<3ecf81fd$0$25955$79c14f64_at_nan-newsreader-01.noos.net>...
> try to use ||
>
>
> select cust_id||cust_name ....
> ...
> group by cust_id||cust_name
>
>
> will return something like '00001TOTO'
Already tried this; doesn't work.
Catalin
> "Catalin Trifu" <catalin_at_isp-software.de> a écrit dans le message de
> 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 - 12:13:42 CDT