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 -> 'SUM' strings to concatenated string

'SUM' strings to concatenated string

From: Alexander Mueller <millerax_at_hotmail.com>
Date: Fri, 17 Feb 2006 10:23:50 +0100
Message-ID: <43f59627$0$506$9b4e6d93@newsread4.arcor-online.net> 





Hi



i am looking for a way to concatenate all values
of query (that returns one varchar-field with multiple rows)
into one string:



e.g:


  select username from table_users



returns:


  Miller


  Smith


  Frankfurter


  Gonzales



i want:


  Miller;Smith;Frankfurter;Gonzales



How can i 'SUM' strings, btw we are using ora 8i.



Thanks for time and help,


Alex
Received on Fri Feb 17 2006 - 03:23:50 CST












Original text of this message













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