Re: using select to concatenate into a string?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 21 Jul 2006 21:06:39 +0200
Message-ID: <44c125c0$0$31658$626a54ce@news.free.fr>

<kimberly.shaffer_at_gmail.com> a écrit dans le message de news: 1153506780.865682.82470_at_h48g2000cwc.googlegroups.com...
| dilemma: using a select statement ONLY
|
| is it possible to get the results to concatenate in a string such as?
|
| select field from table;
|
| original results
| --------------------
| 1 cat
| 2 dog
| 3 mouse
|
| wanted results
| ---------------------
| 1 cat, dog, mouse
|

Yes, search for "pivot" on asktom.oracle.com or google

Regards
Michel Cadot Received on Fri Jul 21 2006 - 14:06:39 CDT