Table
Column1 Column2
V1 'Chaine1'
V1 'Chaine2'
V2 'Chaine3'
V2 'Chaine4'
The result expected :
V1 'Chaine1;Chaine2'
V2 'Chaine3;Chaine4'
2 Methods :
1. Create a User-Defined Aggregation function :
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2196162600402
2. Use this Query :
SELECT Colonne1,
REPLACE(
REPLACE(xmlagg(xmlelement(unusedElem,Colonne2 ||
';'))
,'
,'
FROM
TABLE
GROUP BY Colonne1
2 commentaires:
Hello. This post is likeable, and your blog is very interesting, congratulations :-). I will add in my blogroll =). If possible gives a last there on my blog, it is about the Plotter, I hope you enjoy. The address is http://plotter-brasil.blogspot.com. A hug.
http://mkourde-blog.blogspot.com/
Enregistrer un commentaire