How to flatten cols into rows

I have a single table, as follows:

Col_A       Col_B
------      ------
Joe          X
Joe          Y
Joe          Z
Bob          A
Bob          B

and I need to have a result set that looks like:

Joe          X Y Z
Bob          A B

The first column may have anywhere from 1 to max of 5 entries. Is this possible in SQL, or do I need to do it in PL/SQL?

TIA Pete Received on Fri Jan 30 2004 - 01:22:22 CST