I am new to SQL and are having a tough time with this particular query. I need a way to group multiple records into one and concatenate text data from a single field.

If this is the data within the table:

ID SEQ SOME_FIELD
1 1 Mark
1 2 Paul
1 3 John
2 1 Mark
2 2 Paul
3 1 Chris
3 2 Jen
3 3 John
3 4 Doug
3 5 Steve

This is what I want to return in the query:

ID SOME_FIELD
1 Mark, Paul, John
2 Mark, Paul
3 Chris, Jen, John, Doug, Steve

I really need it to be a concatenated result with some delimiter.

I am using Oracle 9i.