Hi I have a table test which has the following structure

Name Null? Type
----------------------------------------- -------- ----------------------------
COL1 NUMBER
COL2 VARCHAR2(50)
COL3 NUMBER

The first column is a ID column and the last column is a sequential number Column.

It has got the following values
COL1 COL2 COL3
---------- -------------------------------------------------- ----------
1 BARATAM 1
1 PRASAD 2
1 RAO 3
2 P 1
2 C 2
2 M 3
2 BALAJI 4

7 rows selected.

A set of ID's refers to one particular Employee. and the last column is the sequence in which it is to appear. The output I require is

BARATAM PRASAD RAO
P C M BALAJI

Can any one please help me on the this.

Regards
Dinesh