Re: Avoiding external join by joining strings

> Hi,
>
> I have a program, which reads a list of rows from table A. There is a
> 1:n relation
> between table A and B. For any row we find in A, we start a query for
> the matching rows in B , reading the "name" column. Finally, we
> concatenate these "name"
> columns into a string like
>
> "name1, name2, name3"
>
> Is it possible, to let Oracle do the concatenation? If so, we could
> avoid the per row queries (which I call external join), thus possibly
> speeding up the operation a lot.

Jochen, it is possible, and a discussion thereof would be on my homepage as well: http://www.adp-gmbh.ch/ora/sql/user_def_agg.html

hth
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/