Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Merge Multiple Rows Into Single Result

Merge Multiple Rows Into Single Result

From: Niko <nick_wakefield_at_hotmail.com>
Date: 14 Nov 2002 08:35:37 -0800
Message-ID: <9da94cd1.0211140835.56fa096b@posting.google.com>


Hi,

Does anyone know a way to do the following, given a table like

Field_A, Field_B

a         first word
a         second word
a         third word


then runa group by query on it to merge the contents of field_b seperating with commas.

select field_a, merge(field_b,',')
from table
group by a

resulting in
Field_A New_String
a first word, second word, thrid word Received on Thu Nov 14 2002 - 10:35:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US