Multi Rows String concatenation

From: Catalin Trifu <catalin_at_isp-software.de>
Date: 24 May 2003 05:50:42 -0700
Message-ID: <d0b5fe87.0305240450.77461fd4@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 - 07:50:42 CDT