I'm placing the question here because it really isn't pressing to accomplish the task I have in mind.

First, I'm not much of a programmer, second, I have taken time to research my problem.

My problem is this: I have this itching sensation on my backsi.....ooops, wrong forum...lol

In all seriousness. I would like to populate a table with data from another table. I have a table that is stuctured like this:

creditor varchar2(30),
service date,
cost number(5),
paid number date));

I would like to populate a second table that would look like this:
creditor varchar2(30),
sumOfCost number(5));

Th sql I would like to use is select creditor, sum(cost) from table group by creditor.

What pl/sql would accomplish this?