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 -> HELP: Database Record Rollup

HELP: Database Record Rollup

From: Marc A. Lefebvre US-775 <lefebvre_at_iwavesolutions.com>
Date: 23 Aug 2004 16:41:11 -0700
Message-ID: <5ef1a86c.0408231541.50a12ce6@posting.google.com> 





I have a source database table that has the form:



ID   TYPE   TEXT


1    1      AAAA
2    1      BBBB
3    2      CCCC
4    2      DDDD
5    2      EEEE






And I need to output in the following form:



TYPE TEXT



1    AAAA BBBB



2    CCCC DDDD EEEE



Where the TEXT field is concatenated based on type.  What SQL
statement would produce such an output?



Thanks!



Marc
Received on Mon Aug 23 2004 - 18:41:11 CDT












Original text of this message













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