Can someone please tell me how to transpose one column of several rows into
one column by one row using an oralce 8i query.

example from this
table A
col1
row1 A
row2 B

to this
table B
col1
row1 A,B

delimator can be any char