Vertical result with Oracle SQL?

Hi guys,
Here is what I need to get.

Columns: Id, Name, Program, cost
Data sample:

1, George, Program 1, $10
1, George, Program 2, $10
1, Peter, Program 1, $10

The result line should looks like this:
1; George, Peter; Program 1, Program 2, $30

Basically I need to concatenate Names and Programs and sum the cost for each ID

I am stuck here; any idea would be greatly appreciated

Thanks
Georgino Received on Tue Sep 11 2007 - 15:53:51 CDT