Re: Converting many rows to single row.

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 9 Nov 2006 05:03:38 -0800
Message-ID: <1163077418.168520.195830@k70g2000cwa.googlegroups.com>

schan_k 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,

Search the comp.databases.oracle.misc group for "Reduce To Ranges aggregate function":
http://groups.google.com/group/comp.databases.oracle.misc/browse_thread/thread/8baf24374b3e5bd3/1a86756f635217c2? (Oct 19, 2006)

There are a couple examples in that thread that show how to do what you want. The examples are for a single table, but will also work if you join two tables.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Thu Nov 09 2006 - 07:03:38 CST