Multiple columns -> comma-seperated list in one column

Hi....

I need a little help.

Lets say I have a table with the following values:

COL1 COL2
--------- ---------

VAL11	  VAL21
VAL11	  VAL22
VAL11     VAL23
VAL11     ...
VAL12     VAL21
VAL12     VAL24
VAL12     ...
...	  ...

Now, what I want to do, is to see it as follows:

COL1 COL2

--------------- ------------------------
VAL11           VAL21, VAL22, VAL23, ...
VAL12           VAL21, VAL24, ...
...             ...

Anybody have any idea how to do that, using a simple SQL or PL/SQL statement?

Kind Regards
Adam Received on Thu Oct 28 1999 - 10:06:04 CDT