Re: Converting many rows to single row.

On 2006-11-09, schan_k <karthiksubram_at_gmail.com> wrote:
> Hi,
> I have 2 tables table A and Table B. For each record in
> table A there are many records in Table b (one-many) . Is it possible
> to have a query which will list all the values of 2 table to be
> represented in one row for a given value of A.
>
> Thanks,
>

See http://www.adp-gmbh.ch/ora/plsql/pipeline.html#pivot and http://www.adp-gmbh.ch/ora/sql/examples/pivot.html

hth, Rene

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